How can I tell what Oracle instance I am connected to in sqlplus?

  • Document ID:KM02736847
  • Creation Date:17-Feb-2017
  • Modified Date:09-Mar-2021
    • Micro Focus Products:
      data protector 9.09

Summary

The command to tell what instance one is connected to in sqlplus

Question

How can I tell what Oracle instance I am connected to in sqlplus?

Answer

After signing into Oracle's sqlplus, the command is as follows :

    select instance_name from v$instance

Here is an example :

 

 

SQL> select instance_name from v$instance;

INSTANCE_NAME

----------------

QDB

SQL>