Blocked-session details : V_SESSION « System Tables Data Dictionary « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. System Tables Data Dictionary
  3. V_SESSION
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>








30.120.V_SESSION
30.120.1.Users in rollback segments
30.120.2.Blocked-session details
30.120.3.Dynamic Performance Views: V$SESSION contains information about each connected user or process in the database