Synopsis

Values:0 to DB_BLOCK_BUFFERS

Default:0.1 × DB_BLOCK_BUFFERS

Multiple Instances:Should have the same value

Specifies the maximum size of a cached partition of a table that will be split among the caches of multiple instances. If the partition is larger than the value of this parameter, the table will not be split among the instances’ caches. The default value of this parameter is one-tenth the number of database blocks in the buffer cache. This parameter can also be used to specify the maximum size of a cached partition for a single instance.