| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL/SID question
Haresh Assumal wrote:
>
> How do I find what my current SID is when I'm in SQLplus?
> -Haresh
There is no way to find the ORACLE_SID from the data dictionary. Most DBAs name their database the same as the ORACLE_SID for just that reason. Relying on V$DATABASE only works if one has ensured the name and the SID are the same.
Michael
+--------------------------------------------- + Michael Abbey Author of 5 works in the+ Ottawa Canada Oracle Press Series
+---------------------------------------------Received on Tue Sep 30 1997 - 00:00:00 CDT
 |
 |