1. From within Oracle SQL*Plus session.
2. Using the userenv(‘SESSIONID’) to retrieve current sid and serial#.
select sid, serial# from v$session where audsid=userenv(‘SESSIONID’);
SQL> select sid, serial# from v$session where audsid=userenv(‘SESSIONID’);
SID SERIAL#
———- ———-
408 16328
SQL>
3. Note: That logging out of SQL*Plus session or reconnecting will change your SID and SERIAL#.
Larry Catt
OCP