Re: How to find SID

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 1 Nov 2001 17:02:21 +0100
Message-ID: <tu348kte61e743@corp.supernews.com>

"Nasir" <nmajeed_at_prosrm.com> wrote in message news:3be1628d$0$13458$39cecf19_at_nnrp1.twtelecom.net...
> Is there a way to query Oracle server to find out SID for the instance ?
>
> Thanks,
> Nasir
> nmajeed_at_prosrm.com
>
>
>

select * from v$instance or select * from v$database, depending on version, which you -sigh- don't mention.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address

Received on Thu Nov 01 2001 - 10:02:21 CST