[Oracle] SID 조회

출처 : http://blog.naver.com/dolmang7/150037571097

-- SID 조회
SELECT instance FROM v$thread;

-- GLOBAL_NAME 조회
SELECT * FROM props$ WHERE name='GLOBAL_DB_NAME';
SELECT * FROM global_name;

-- GLOBAL_NAME 수정
ALTER DATABASE RENAME GLOBAL_NAME TO 'NAME';