hepdba

Showing posts with label DBA Monitor. Show all posts
Showing posts with label DBA Monitor. Show all posts

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