Wednesday, November 7, 2012

As a normal user how to check SID

select sys_context('USERENV','SID') from dual;


(or)

select sid from v$mystat where rownum <=1;