Moneycontrol Brokerage Recos

Thursday, August 1, 2019

Find your own session SID in Oracle






Use below SQL command to find your own connected session details for Oracle Database.

-bash-4.1$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.4.0 Production on Thu Aug 1 02:52:37 2019

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Data Mining and Real Application Testing options

SQL>    select sys_context('USERENV','SID') as MY_SID from dual;

MY_SID
------
3345

SQL>

So above, you can see your connected session SID is 3345.

No comments:

Post a Comment