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