Tuesday, 16 December 2014

DBA Monitor

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’);

No comments:

Post a Comment