Dynamic Performance Views: V$SESSION contains information about each connected user or process in the database : 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, serial#, username, program from v$session
  2  where username = 'HR';

no rows selected








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