First page Back Continue Last page Graphics
Database Block Size
Default block size assigned at database creation time
Defined with the DB_BLOCK_SIZE parameter
Must be used with the SYSTEM, TEMPORARY, and ROLLBACK tablespaces
Oracle9i new feature
- Two types of block sizes: standard and non-standard
Notes:
Oracle9i now supports two types of block sizes in a single database: standard and non-standard.
The standard database block size is defined at database creation time by the DB_BLOCK_SIZE initialization parameter and as with previous versions of Oracle it cannot be changed without recreating the database. The standard database block size must be used for the SYSTEM, TEMPORARY, and ROLLBACK tablespaces and is the default block size used for other tablespaces.
Oracle9i supports up to four non-standard block sizes in a single database. A non-standard block size is simply a different block size from the standard. Turn to the next page for an example and more discussion.