DB_nK_CACHE_SIZE

Parameter type	Big integer
Syntax	DB_nK_CACHE_SIZE = integer [K | M | G]
Default value	0M (additional block size caches are not configured by default)
Parameter class	Dynamic: ALTER SYSTEM
Range of values	n = 2, 4, 8, 16, 32

DB_nK_CACHE_SIZE 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, 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.

Platform-specific block size restrictions apply. For example, you cannot set DB_32K_CACHE_SIZE if the maximum block size on the platform is less than 32 KB. Also, you cannot set DB_2K_CACHE_SIZE if the minimum block size is greater than 2 KB.

See Also: For more information on block size restrictions, see your platform specific documentation