Query v$session for user name, sid and serial# : session « System Tables Data Dictionary « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Tables Data Dictionary
3. session

SQL>
SQL>
SQL> column username format a15 word_wrapped
SQL> column module format a15 word_wrapped
SQL> column action format a15 word_wrapped
SQL> column client_info format a30 word_wrapped
SQL>
SQL> select username||'('||sid||','||serial#||')' username,
  2         module,
  3         action,
  4         client_info
  5  from v$session
  6  where module||action||client_info is not null;

USERNAME        MODULE          ACTION          CLIENT_INFO
--------------- --------------- --------------- ------------------------------
JAVA2S(32,1171) SQL*Plus        processing row  owner=SYS
                                6547


SQL>