latch free

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

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

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