Blocked-session details : V_SESSION « System Tables Views « Oracle PL / SQL






  1. Oracle PL / SQL
  2. System Tables Views
  3. V_SESSION

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>








Related examples in the same category

1.Dynamic Performance Views: V$SESSION contains information about each connected user or process in the database
2.Select the default value from V$SESSION.CLIENT_INFO.