The process waits for a latch that is currently busy (held by another process).
Wait Time: The wait time increases exponentially and does not include spinning on the latch (active waiting). The maximum wait time also depends on the number of latches that the process is holding. There is an incremental wait of up to 2 seconds.
| Parameter | Description |
|---|---|
| address | The address of the latch for which the process is waiting |
| number | The latch number that indexes in the V$LATCHNAME view.To find more information on the latch, use the following SQL statement:
select *
from v$latchname
where latch# = number;
|
| tries | A count of the number of times the process tried to get the latch (slow with spinning) and the process has to sleep |
Oracle Database Internal Mechanism 