Oracle RAC Transaction Locks Test
A transaction lock held for too long a time will prevent other sessions from accessing the database object, thereby stalling critical database operations. It is hence imperative to monitor the transaction locks to each database instance in an Oracle RAC. Using the RAC Transaction Locks test, you can determine the number of transaction locks held by each database instance and the duration of these locks, so that you can quickly identify the instance holding a large number of transaction locks and that which is holding locks for an unreasonably long time.
Target of the test : Oracle RAC
Agent deploying the test : An internal/remote agent
Outputs of the test : One set of results for each instance of the monitored Oracle RAC.
|
Measurement | Description | Measurement Unit | Interpretation |
---|---|---|---|
Number of Locks: |
Indicates the number of locks held by this instance. |
Number |
A high value may indicate one of the following:
|
Average wait time: |
Indicates the time for which the locks were held by this instance. |
Seconds |
A high value may indicate one of the following:
|