Re: SID Name in Database?

In article <1993Oct12.153308.8520_at_walter.cray.com>, csoderbe_at_garond.cray.com (Curt Soderberg) writes...
>
>
>
>Oracle Users:
>
>
> Can someone tell me which table in V6 stores to database SID? I've
>got a user who would like to use this and I can't find it anywhere.
>
>
>Thanks in advance,
>
>Curt
>--
>---------------------------------------------------------------
>Curt Soderberg Cray Research, Inc.
>Oracle DBA 655E Lone Oak Drive
>csoderbe_at_cray.com Eagan, MN 55121

The following 2 posts are reprinted without permission:

Path: skates.gsfc.nasa.gov!ames!elroy.jpl.nasa.gov!usc!wupost!trinews.sbc.com!nuntius From: David R. Thrash <dthrash_at_sbctri.sbc.com> Newsgroups: comp.databases.oracle
Subject: Re: Table that contains the Oracle_SID of the database ? Date: 19 Jun 1993 22:05:56 GMT
Organization: Southwestern Bell - Technology Resources Lines: 13
Distribution: world
Message-ID: <2002k4$62j_at_sbctri.sbc.com> References: <1993Jun17.040058.29614_at_cmutual.com.au> NNTP-Posting-Host: mac-thrash.sbc.com
X-UserAgent: Nuntius v1.1

In article <1993Jun17.040058.29614_at_cmutual.com.au> Tony Cook, btc_at_cmutual.com.au writes:
>--

Here's what I use in V6 :

create view sid (id) as
select value from v$parameter where name = 'db_name' /
grant select on sid to public
/
create public synonym sid for sid
/  

Path: skates.gsfc.nasa.gov!ames!haven.umd.edu!uunet!mcsun!dkuug!dde!mj From: mj_at_dde.dk (Martin Jensen)
Newsgroups: comp.databases.oracle
Subject: Re: Table that contains the Oracle_SID of the database ? Message-ID: <1993Jun21.104915.8517_at_dde.dk> Date: 21 Jun 93 10:49:15 GMT
References: <1993Jun17.040058.29614_at_cmutual.com.au> <1993Jun18.030522.24700_at_coulomb.pcc.oz.au> Organization: Dansk Data Elektronik A/S
Lines: 20

oracle_at_coulomb.pcc.oz.au (Oracle System Account) writes:

>Tony,
 

>There is no such v$ table storing ORACLE_SID. However, you can still get
>ORACLE_SID by issuing the following:
 

> SQLDBA> show parameter db_name

Well, well. If you are not afraid of using not documented features, you could try the following select from the sys account:

select ksqdngdn from x$ksqdn

Best wishes

-- 
Martin Jensen,  Dansk Data Elektronik A/S, Herlev, Denmark
E-mail:      ..!uunet!mcvax!dkuug!dde!mj  or  mj_at_dde.DK
                        ---
Don't take life too seriously -- you'll never get out if it alive.