How to find your own session
SELECT sid FROM v$mystat WHERE rownum = 1;
SELECT sid FROM V$SESSION WHERE audsid = userenv(‘sessionid’);
SELECT sid FROM V$SESSION WHERE audsid = SYS_CONTEXT(‘userenv’,'sessionid’);
SELECT sid FROM v$mystat WHERE rownum = 1;
SELECT sid FROM V$SESSION WHERE audsid = userenv(‘sessionid’);
SELECT sid FROM V$SESSION WHERE audsid = SYS_CONTEXT(‘userenv’,'sessionid’);
No comments:
Post a Comment