Tag Archives: wait events

Oracle Wait Events That Everyone Should Know Part -III

Last updated on July 29th, 2016 at 02:19 amThis is part III in series of Oracle Wait Events That Everyone Should Know First two parts link are Oracle Wait Events That Everyone Should Know Part -I Oracle Wait Events That Everyone Should Know Part -II Lets get going with the Third part db file scattered read The process has issued an I/O request to read … Continue reading Oracle Wait Events That Everyone Should Know Part -III »

Oracle Wait Events That Everyone Should Know Part -1

Last updated on July 28th, 2016 at 05:59 pmThis is part I in series of 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 … Continue reading Oracle Wait Events That Everyone Should Know Part -1 »