Name
CACHE_SIZE_THRESHOLD
Synopsis
Value: 0-DB_BLOCK_BUFFERS
Default: 01 * DB_BLOCK_BUFFERS
Specifies the maximum size of a cached partition of a table split among the caches of multiple instances. If the partition is larger than the value of this parameter, the table is not split among the instances’ caches. Multiple instances should have the same value. This parameter can also specify the maximum cached partition size for a single instance. Obsolete with Oracle8i.
Get Oracle in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.