The Memory Structures Layer

A transaction lock is acquired when a transaction initiates its first change and is held until the transaction does a COMMIT or ROLLBACK. It is used mainly as a queuing mechanism so that other sessions can wait for the transaction to complete.

The test mapped to this layer reports the number and duration of transaction locks held by each instance of the cluster.


Figure 1 : The tests mapped to the Memory Structures layer