Ho to find your own sid username and serial# in oracle

<<Back to DB Administration Main Page

Find out your own Session Information in oracle

select  sys_context ('USERENV','SID')FROM dual;
select sys_context('USERENV','SESSIONID') FROM dual;
select sys_context('USERENV','SESSION_USER') FROM dual;

OR

select sid, serial#, username  from v$session where sid = ( select sid from v$mystat where rownum = 1);

Example:

SQL> select sid, serial#, username  from v$session where sid = ( select sid from v$mystat where rownum = 1);

     SID    SERIAL# USERNAME
-------- ---------- ---------------
      10      62786 SYS

1 row selected.