NISCHAL's DBA WORLD

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;
Posted by PVS VAMSI at 12:47 AM
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Blog Archive

  • ►  2008 (23)
    • ►  April (4)
    • ►  May (4)
    • ►  June (12)
    • ►  July (1)
    • ►  August (2)
  • ►  2009 (52)
    • ►  January (9)
    • ►  February (1)
    • ►  March (12)
    • ►  April (1)
    • ►  May (6)
    • ►  June (3)
    • ►  July (4)
    • ►  August (3)
    • ►  September (6)
    • ►  October (1)
    • ►  November (4)
    • ►  December (2)
  • ►  2010 (4)
    • ►  January (1)
    • ►  March (1)
    • ►  July (1)
    • ►  December (1)
  • ►  2011 (2)
    • ►  January (1)
    • ►  February (1)
  • ▼  2012 (3)
    • ►  May (2)
    • ▼  November (1)
      • As a normal user how to check SID
  • ►  2014 (1)
    • ►  November (1)
Picture Window theme. Powered by Blogger.