hi, from dbs directory, we can get the SID of oracle just by looking at the initSID.ora. BUT is there anyway where we can get the SID from sqlplus? thanks
Printable View
hi, from dbs directory, we can get the SID of oracle just by looking at the initSID.ora. BUT is there anyway where we can get the SID from sqlplus? thanks
select instance from v$thread;
Cheers,