Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

Blocked-session details

SQL> SQL> select sid, blocking_session, username, blocking_session_status,   2  program, event, seconds_in_wait   3  from v$session   4  where blocking_session_status = 'VALID'; no rows selected SQL>