block size - cheeyoung/sqlplus-public GitHub Wiki
DB_BLOCK_SIZE
value | ||||
---|---|---|---|---|
32768 | 32K | 12MB | 128TB | |
8192 | 8K | 7MB | 32TB | default |
4096 | 4K | |||
2048 | 2K |
Reference
The value of this parameter must be a multiple of the physical block size at the device level.
For Oracle Real Application Clusters (Oracle RAC), this parameter affects the maximum value of the FREELISTS storage parameter for tables and indexes. Oracle uses one database block for each freelist group. Decision support system (DSS) and data warehouse database environments tend to benefit from larger block size values.