Options for reducing space map page contention

When you define table spaces and indexes, you have several options to help reduce space map hot spots. These hot spots can occur when a large amount of update, insert, or delete activity occurs on a page set from multiple members of a group.

The MEMBER CLUSTER option can reduce contention when doing heavy sequential inserts, and the TRACKMOD NO option can reduce contention when any type of insert, update, or delete activity occurs. The TRACKMOD NO option cannot be used when incremental image copies are used for a tablespace.

Understand the implications of each option before choosing either one, as both options have drawbacks.