Oracle – Query System Variables – What is your Instance name

Oracle – Query System Variables – What is your Instance name

Query v$instance

  select INSTANCE_NAME from v$instance;

sys_context:

  select sys_context('userenv', 'db_name') from dual

References

  1. How to get SID (Instance name) without SYS DBA?
    http://forums.oracle.com/forums/thread.jspa?threadID=622348 
  2. Oracle Database SQL Reference – SYS_CONTEXT
    http://www.filibeto.org/sun/lib/nonsun/oracle/10.1.0.2/B14117_01/server.101/b10759/functions150.htm

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s