Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to get the oracle SID name ?

Re: How to get the oracle SID name ?

From: Colin Davies <colin_at_SPAMOFF.mgmtdimensions.com>
Date: 03 Jan 1999 10:03:03 PST
Message-ID: <368fb009.24865559@news.mdi.cncoffice.com>


Look in the dynamic views V$SESSION or V$INSTANCE.

On Sun, 3 Jan 1999 15:40:08 +0100, "Adrian" <adrian.moor_at_swol.de> wrote:

>Hi everybody,
>
>does enybody know, how to get the oracle SID-ALIAS name (alias for the
>instance from the tnsnames.ora file)
>from a PLSQL programm or from sqlplus ?
>
>Im working with Oracle Rel. 7.3.
>
>my email is: adrian.moor_at_swol.de
>
>many thanks for your tip.
>
>

Colin Davies
Delete the SPAMOFF. from my email address to reply. Spammers are sewer rats! Received on Sun Jan 03 1999 - 12:03:03 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US