Using Cache Partitions

Cache partitions can be used to reduce cache spinlock contention without needing to create separate caches and bind database objects to them.

For more information on monitoring cache spinlock contention, see the Performance and Tuning Guide.

You can set the default number of cache partitions for all caches with the configuration parameter global cache partition number. See the System Administration Guide.