Kflakes# 2012-1 : Get Oracle SID without sysdba priviledge

Here is a simple tips to find oracle SID with/without SYSDBA privilege.

To get oracle SID without SYS_DBA priviledge:
select sys_context('userenv','instance_name') from dual;

To get database name
select sys_context('userenv','db_name') from dual;

--

Contents are compiled from different resources. Respective copyrights are acknowledged.