September 2018

How to find blocked and blocking sessions

1) Find the session id (SID), serial# and instance (inst_id) of your session that is hanging. 2) Is your session being blocked? SELECT s.blocking_status, s.blocking_session, s.event FROM gv$session s WHERE s.sid = [789] AND s.serial# = [98543] AND s.inst_id = [1] If any one of these three is true: 1) The blocking_status is VALID or […]

Read more →