Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: System ID
select name, value
from v$parameter
where name = 'db_name';
Yes - use lower case for db_name, and the query needs to be run from a DBA account.
Jerry Metz wrote:
> Can anyone tell me how I can retrieve the System ID (SID) from the
> database? It's been a gazillion years since I did this, but I seem to
> remember SELECT SID from DUAL; or something like that. Any help would
> be appreciated.
>
> Jerry
>
> ------------------------------------------------------------------------
>
> Jerry Metz <jmetz1_at_ix.netcom.com>
> Director, Consulting
> G.L. Metz & Associates
>
> Jerry Metz
> Director, Consulting <jmetz1_at_ix.netcom.com>
> G.L. Metz & Associates
> Work: 847-215-4771
> Fax: 847-215-4772
> Netscape Conference Address
> Netscape Conference DLS Server
> Additional Information:
> Last Name Metz
> First Name Jerry
> Version 2.1
Received on Fri Mar 27 1998 - 00:00:00 CST