Re: instance name

"Dave Bottom" <brooktrout_at_ctel.net> wrote in message news:d8M85.315$P2.6931_at_harpo...
> select name from v$database;

That won't work -that will tell you the database name, which isn't the same thing as the Instance name at all!! Convention has it that the instance and the database should be named the same, but since there's no enforcement of that, it would be dodgy to rely on the v$database view. As others have suggested, V$INSTANCE is the way to go.

Regards
HJR
>
> "SP" <spant1_at_aol.com> wrote in message
> news:ItL85.1433$0x.44420_at_nuq-read.news.verio.net...
> > How do you find out what instance Oracle is currently running?
> > SP
> >
> >
>
>
Received on Sat Jul 08 2000 - 00:00:00 CDT