Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
Get Live Help
You have selected a product bundle. Can you please select the individual product for us to better serve your request.*
There is not a technical support engineer currently available to respond to your chat. For prompt service please submit a request using our service request form.
The following articles may solve your issue based on your description.
The Locks Activity collection provides locks activity-related data.
Average Lock Duration
The average time (in milliseconds) that a resource was locked (held in contention).
High values of lock duration may indicate aggressive lock incidence which may be improved through tuning.
The metric is calculated as follows:
100 * (Lock Wait)
The total number of times an enqueue request or conversion resulted in a wait.
Enqueue Waits Ratio
The percentage of enqueue wait events (waits resulting from enqueue requests or conversions) within the total time consumed by enqueue operations.
The total number of enqueue requests or enqueue conversions for this type of enqueue.
The percentage of lock requests of this type within the total number of lock requests
The percentage of lock requests that did not escalate to a blocking lock.
The name of the lock.
The total amount of time spent waiting for the enqueue or enqueue conversion.
The percentage of waits for this type of lock, of all the locks.
The Locks Breakdown collection provides lock requests and wait information, including the percentage of time spent on locks of the following types: system, TX, TM, User-defined.
In multitenant architectures, the name of the pluggable database.
System Locks Percentage
The percentage of time the sessions spent waiting on System locks, out of the entire time spent waiting on locks.
System Locks Wait Time
The percentage of time the sessions spent waiting on System locks.
TM Locks Wait Time
The amount of time the sessions spent waiting on TM locks.
The percentage of time the sessions spent waiting on TM locks, out of the entire time spent waiting on locks.
Total Lock Wait
The total time the sessions spent waiting on locks.
TX Locks Wait Time
The amount of time the sessions spent waiting on TX locks.
The percentage of time the sessions spent waiting on TX locks, out of the entire time spent waiting on locks.
UL Locks Wait Time
The amount of time the sessions spent waiting on user-defined lock types.
The percentage of time the sessions spent waiting on user-defined locks, out of the entire time spent waiting on locks.
The Locks Instance collection provides summarized lock requests and application efficiency information.
Balance Enqueue Waits
The extent, in percents, to which enqueue wait events are balanced across RAC nodes
Balance Lock Efficiency
The extent, in percents, to which lock efficiency is balanced across RAC nodes
Balance Lock Wait
The extent, in percents, to which lock wait events are balanced across RAC nodes
Total number of waits on enqueues
The percentage of total locks waits within the total lock requests
The Locks Tree Instance collection provides lock tree information at the instance level.
The SQL statement waiting for lock release.
The session serial number is either:
The session identifier for the session is holding the object (locking).
The name of the Client machine
The lock is between different cluster nodes for global locks.
DB User Name
The Oracle user, which is either:
The host where the Oracle instance is installed, which is either:
The Oracle instance session is either:
The wait length of time, in seconds.
The event on which the blocked session is waiting
The lock mode in which the session holds the lock
Lock Request Mode
The lock mode in which the process requests the lock
The type of user or system lock.
The object requested for lock.
OS User Name
The OS user name with which the session logged in is either:
The operating system process ID for the Oracle server process. The process ID is either:
The operating system program is either:
The blocked session’s system ID (SID)
You can find online support help for Quest *product* on an affiliate support site. Click continue to be directed to the correct support content and assistance for *product*.
The document was helpful.
I easily found the information I needed.
© 2022 Quest Software Inc. ALL RIGHTS RESERVED.
The Quest Software Portal no longer supports IE8, 9, & 10 and it is recommended to upgrade your browser to the latest version of Internet Explorer or Chrome.
Upgrade to IE 11 Click here
Upgrade to Chrome Click here
If you continue in IE8, 9, or 10 you will not be able to take full advantage of all our great self service features.