DBPedias

All your database knowledge are belong to you

Oracle

Wait Events - latch activity

latch activity

This event is used as part of the process of determining whether a latch needs to be cleaned. Wait Time:

0.05 to 0.1 seconds

Parameter Description
address The address of the latch that is being checked
number

The latch number of the latch that has activity. To find more information on the latch, use the following SQL statement:

select *
from v$latchname
where latch# = number;
process# If this is 0, it is the first phase of the in-flux tests