3 ms·
8k is a very common page size, but 4k isn't unheard of. Oracle's default is 4k. The issue is that page size caps row size (for on-row storage). Also, if you ha
by da_chicken 2y ago
8k is a very common page size, but 4k isn't unheard of. Oracle's default is 4k.
The issue is that page size caps row size (for on-row storage). Also, if you have a smart clustering index, larger pages can be more efficient use of index addressing. So it's a trade-off.
- hans_castorp 2y agoOracle defaults to 8k as well: https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/DB_BLOCK_SIZE.html https://docs.oracle.com/en/database/oracle/oracle-database/1... > Default value 8192