Friday, September 14, 2012

ORACLE Find SID of a currently connected Schema/Instance


Ref: http://stackoverflow.com/questions/6288122/checking-oracle-sid-and-database-name

The following query is useful to find SID from the connected session.

select sys_context('userenv','instance_name') from dual;


No comments: