|
Explanation: The maximum block size supported for the Oracle 9i database is 32KB. In Oracle 9i, you can have multiple block sizes for different table spaces. This is a new feature that was not available in Oracle8i. The block size can be specified while creating a table space using the CREATE TABLE SPACE command. Before creating a table space with a nondefault block size, you should reserve the buffer space by dynamically initializing the DB_nK_CACHE_SIZE parameter with the appropriate block size. Reference: Oracle 9i Net Services Administrator’s Guide Oracle 9i Net Services Reference Guide Oracle 9i Recovery Manager Reference Oracle 9i Backup and Recovery Concepts
|