Re: Table that contains the Oracle_SID of the database ?

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.