CODEWITHSUNDEEP
sqloracle10g
azec.me
azec.me

Reputation: 5078

Finding ORACLE_SID for database?

Is there any way to find out which SID belongs to which database in Oracle database, by executing sql query?

Upvotes: 0

Views: 18261

Answers (1)

Zabba
Zabba

Reputation: 65517

Check it out:

select instance from v$thread

select distinct sid from v$mystat

select * from global_name

Upvotes: 4

Related Questions