Tag Archives: wait events

Oracle Wait Events That Everyone Should Know

Here are some of the Common Oracle wait events that everyone should Know. Wait events You can find which event session is waiting for it by following query select event from V$session_wait where sid=&1 I am trying to explain few common Oracle wait events ,there causes and resolutions enqueue The process is waiting on an enqueue (a lock you can see in v$lock). This commonly … Continue reading Oracle Wait Events That Everyone Should Know »