Re: What is the Oracle SID?

From: Jose Francisco Gomez Diez <jfgomez_at_fimestic.es>
Date: Wed, 23 Sep 1998 10:33:22 +0200
Message-ID: <6uabnr$7gk$1@talia.mad.ibernet.es>

Hi!

Connect as sys or system and run this query:

select * from v$database;

Regards,

                     Jose Francisco Gomez Diez <jfgomez_at_fimestic.es>
                     Fimestic S.I. A.I.E. - Retama 3, 3º 28045 Madrid
                     Telefono: +34 91.337.07.40 - Fax: +34 91.527.96.75

----------------------------------------------------------------------------

spam-off email.sps.mot.com (Alan Long) escribió en mensaje ...

>I connect to several different servers to run sqlplus or PL/SQL queries.
>Is there any way sqlplus can identify the server (Oracle SID) on which the
>query is running? Something like "select oracle_sid from dual" would be
>nice. I'd like to include this in the btitle.
>
>--
>Alan Long
>
>email tics28@"spam-off"email.sps.mot.com (remove the "spam-off")
Received on Wed Sep 23 1998 - 03:33:22 CDT