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

  • KM02736847
  • 17-Feb-2017
  • 09-Mar-2021

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>