Query v$session : session « System Tables Data Dictionary « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. System Tables Data Dictionary
  3. session
SQL>
SQL> select username, sid, serial#, process, status
  2  from v$session
  3  where username is not null
  4  /

USERNAME                              SID    SERIAL# PROCESS      STATUS
------------------------------ ---------- ---------- ------------ --------
JAVA2S                                 32       1171 1624:1144    ACTIVE

SQL>
SQL>








30.62.session
30.62.1.Query v$session
30.62.2.Query v$session for user name, sid and serial#
30.62.3.Select $lock and $session for locked objects