Oracle9i Database Reference Release 1 (9.0.1) Part Number A90190-02 |
|
Initialization Parameters, 35 of 220
DB_BLOCK_SIZE
specifies the size (in bytes) of Oracle database blocks. Typical values are 2048 and 4096. The value for DB_BLOCK_SIZE
in effect at the time you create the database determines the size of the blocks. The value must remain set to its initial value.
If you are using Oracle9i Real Application Clusters, 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.
See Also:
|
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|