Chat now with support
Chat with Support

Spotlight on Oracle 10.4 - Release Notes

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

  1. Select the Spotlight on Oracle connection in the Spotlight Browser.
  2. 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 Oracle Instance.

Waits

The total number of waits for this lock since the start of the Oracle Instance.

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.

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating