Show Oracle DB Name and SID name

Hello

To find the current DB_NAME and ORACLE_SID:

Query the views v$database and v$thread.

V$DATABASE gives DB_NAME
V$THREAD gives ORACLE_SID

If ORACLE_SID = DB_SID and db_name = DBNAME:

To find the current value of ORACLE_SID:

SVRMGR> select instance from v$thread;

INSTANCE
—————-
DB_SID

To find the current value of DB_NAME:

SVRMGR> select name from v$database;

NAME
———
DBNAME

Hits: 13

Leave a Reply

Your email address will not be published. Required fields are marked *