First page Back Continue Last page Graphics

Non-Standard Blocksize

Notes:

In addition to the standard block size (defined by DB_BLOCK_SIZE), Oracle9i supports a maximum of 4 additional non-standard block sizes within a single database. You can choose from the following block sizes: 2k, 4k, 8k, 16k and, on some platforms, 32k.
A non-standard database block size is assigned to a tablespace with the CREATE TABLESPACE statement BLOCKSIZE parameter. Tablespace blocksize definitions can be monitored with the DBA_TABLESPACES and V$DATAFILE views. A block size column has been added to both views to show the assigned block sizes for each tablespace.
Non-standard block sizes of the same size as the standard block size are not permitted. Query parameter DB_BLOCK_SIZE to determine the default blocksize for your database:
SQL> show parameter db_block_size

NAME TYPE VALUE
------------------------------------ ----------- -------
db_block_size integer 8192

Notes continue on the next page…