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?
    Link
  2. Oracle Database SQL Reference – SYS_CONTEXT
    Link

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s