DBPedias

All your database knowledge are belong to you

Oracle

Wait Events - PX qref latch

PX qref latch

Each parallel execution process has a parallel execution qref latch, which needs to be acquired before the queue buffers can be manipulated. Wait Time:

Wait up to 1 second

Parameter

Description

function

Indicates the type of wait that the session is doing

sleeptime

The amount of time that the session waits (in hundredths of a second)

qref

The address of the process queue for which the session is waits