Lock Activity Page
Locks are mechanism designed to prevent two or more transactions from changing the same Oracle object at the same time, thus preventing the loss or corruption of data in the Oracle database. In Oracle, locking is automatic and invisible to the user, but may affect the performance of the database.
To open the Lock Activity page
- Select the Spotlight on Oracle RAC connection in the Spotlight Browser.
-
Click Activity | Lock Activity.
Lock Activity Grid
| Column | Description |
|---|---|
|
Lock name |
The name, or a brief description of, the lock. |
|
Gets |
The total number of gets for this lock since the start of the |
|
Waits |
The total number of waits for this lock since the start of the |
|
Gets/s |
The rate of gets for this lock. |
|
%Gets |
The number of gets for this lock, expressed as a percentage of the total number of gets for all locks. |
|
Waits/s |
The rate of waits for this lock. |
|
%Wait |
The number of waits for this lock, expressed as a percentage of the total number of waits for all locks. |
|
Waits ms/s |
The amount of time spent waiting for this lock, expressed as a rate of milliseconds per second. |
|
Wait Time (ms) |
The total wait time for this lock, expressed in milliseconds. |
Lock Activity Chart
The Lock Activity chart is a graphical representation of the amount of time that sessions have spent waiting on locks, measured in milliseconds per second.
- Database Concepts | Data Congruency and Consistency
- Oracle Database Administrator's Guide | Monitoring the Database | Monitoring Performance
- Oracle Database Reference | V$LOCK