DB_nK_CACHE_SIZE

Property	Description
Parameter type	Big integer
Syntax	DB_[2 | 4 | 8 | 16 | 32]K_CACHE_SIZE = integer [K | M | G]
Default value	0 (additional block size caches are not configured by default)
Modifiable	ALTER SYSTEM
Range of values	Minimum: 0 (values greater than zero are automatically modified to be either the user-specified size rounded up to the granule size or 4 MB * number of CPUs, whichever is greater) Maximum: operating system-dependent
Basic	No

DB_nK_CACHE_SIZE (where n = 2, 4, 8, 16, 32) specifies the size of the cache for the nK buffers. You can set this parameter only when DB_BLOCK_SIZE has a value other than nK. For example, if DB_BLOCK_SIZE=4096, then it is illegal to specify the parameter DB_4K_CACHE_SIZE (because the size for the 4 KB block cache is already specified by DB_CACHE_SIZE).

Do not set this parameter to zero if there are any online tablespaces with an nK block size.

Operating system-specific block size restrictions apply. For example, you cannot set DB_32K_CACHE_SIZE if the operating system's maximum block size is less than 32 KB. Also, you cannot set DB_2K_CACHE_SIZE if the minimum block size is greater than 2 KB.

Note:

1. This parameter was introduced in Oracle9i.

2. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter

where upper(name) in ('DB_2K_CACHE_SIZE', 'DB_4K_CACHE_SIZE', 'DB_8K_CACHE_SIZE', 'DB_16K_CACHE_SIZE', 'DB_32K_CACHE_SIZE');

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
db_2k_cache_size	0	TRUE	FALSE	IMMEDIATE	TRUE	FALSE	Size of cache for 2K buffers
db_4k_cache_size	0	TRUE	FALSE	IMMEDIATE	TRUE	FALSE	Size of cache for 4K buffers
db_8k_cache_size	0	TRUE	FALSE	IMMEDIATE	TRUE	FALSE	Size of cache for 8K buffers
db_16k_cache_size	0	TRUE	FALSE	IMMEDIATE	TRUE	FALSE	Size of cache for 16K buffers
db_32k_cache_size	0	TRUE	FALSE	IMMEDIATE	TRUE	FALSE	Size of cache for 32K buffers

Oracle initializatoin parameters