Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

Query v$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 ------------------------------ ---------- ---------- ------------ -------- RNTSOFT                                 32       1171 1624:1144    ACTIVE SQL>