RAC Wait event gc buffer busy acquire indicates that the session experiencing this event is waiting on another session on the same instance to release the block. Basically the waiting session is not able to pin a block, and will wait on this event until it can pin the block. (gc buffer busy release means […]

When a SQL runs, the time it takes to run is basically come from the CPU time needed plus the time for waits. The following SQL looks into gv$active_session_history and finds the time the SQL spends on each wait event or CPU The Script — — — sqlwaits.sql — Parameters – none — — Purpose: […]