Way1:
------
select sid from v$session where audsid = sys_context('userenv','sessionid');
Way2:
------
select distinct sid from v$mystat;
Way3:
--------
If DBMS_SUPPORT is installed,
select dbms_support.mysid from dual;
Related Documents
Get IP Address from hostname within Oracle Database
How to find the User who is connected to Oracle
How to know which objects are being accessed by a user
No comments:
Post a Comment