Multiple Block Size Support

zhaozj2021-02-16  75

In the Oracle 9i database, support the same database using different size Oracle blocks, which can define the size of the data block at the tablespace level, for example:

Create TableSpace TBS1 ... blocksize 16k;

Create TableSpace TBS2 ... blocksize 8192;

Among them, blocksize can take 2K, 4K, 8K, 16K, if the operating system is supported, even 32K. The block size of the table space can be viewed via the block_size column value in the DBA_TABLESPACES view.

Like the previous version of Oracle 9i, when you create a database, you still need to specify a DB_BLOCK_SIZE parameter (default database data block size, also a standard block size, Standard block size). The value of this parameter will be used as the default block size when creating a table space (if the new table size of the new table space is not specified), and the value of the db_block_size parameter is still specified when the database is created, unless the database is reconstructed, otherwise it cannot be changed .

have to be aware of is:

• When using partitions, all partitions of a partition table must be in the same blocksize tablespace.

· Index and corresponding tables can be placed in different blocksize tablespaces.

· The block size of the system table space can only be the value of the DB_BLOCK_SIZE parameter.

In the Oracle 9i, the parameter db_cache_size replaces the previous DB_BLOCK_BUFFERS parameter and uses bytes to indicate the size of the high-speed buffer (instead of block).

When we use multiple blocks in a database, you must specify the db_cache_size parameter and set the db_nk_cache_size parameter for the tablespace set for different blocks (at least one DB_NK_CACHE_SIZE parameter), where n can be 2, 4, 8, 16, 32, ie:

The buffer of DB_2K_CACHE_SIZE is a cache specified to access a tablespace object having a 2K data block size;

The buffer of DB_4K_CACHE_SIZE is a cache specified for the tablespace object of the 4K data block size;

The buffer of db_8k_cache_size is a cache specified to access tablespace objects of 8K data block size;

The buffer of db_16k_cache_size is a cache specified to access a tablespace object with a 16K data block size;

The buffer of DB_32K_CACHE_SIZE is a cache specified to access tablespace objects of 32K data block sizes;

Note that N cannot be specified as values ​​identified as the size of the default data block, for example, if DB_BLOCK_SIZE = 8192 (8KB), then the DB_8K_Cache_SIZE parameter cannot be set.

E.g:

Max_sga_size = 700m

Share_pool_size = 80m

DB_BLOCK_SIZE = 8192

DB_CACHE_SIZE = 290M

DB_2K_CACHE_SIZE = 4M

DB_16K_Cache_Size = 16m

转载请注明原文地址:https://www.9cbs.com/read-13926.html

New Post(0)