ORACLE DATABASE NAME, SID 확인법

 

참조)

https://bebeya1.tistory.com/13

 

 

SELECT INSTANCE_NAME, VERSION, STATUS FROM V$INSTANCE;

 

DB를 확인하려면 아래쿼리

SELECT name, db_unique_name FROM v$database;

 

SID를 확인하려면 아래처럼.

SELECT INSTANCE FROM v$thread;