First page Back Continue Last page Graphics

Non-Standard DB Size


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 32k.
For example, if the standard block size in our OLTP database is 8k, we may create a 32k non-standard block size cache to hold objects supporting a decision support application.
A non-standard database block size can be assigned to a tablespace with the CREATE TABLESPACE statement using the BLOCKSIZE parameter. Tablespace 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. Don’t worry now about the syntax of the CREATE TABLESPACE statement; you will learn all about that in the Tablespaces lesson.

Notes for this slide continue on the next page…