Re: SID Name in Database?

From: Yves Noel <noel_at_omega.univ-lille1.fr>
Date: 13 Oct 1993 08:15:10 GMT
Message-ID: <29gdee$cq1_at_netserver.univ-lille1.fr>


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
|>
 You can try : select ksqdngdn from x$ksqdn; (x$ksqdn table belongs to SYS). Bye!

-- 
------------------------------------------------------------------------------
    _/_/_/_/    _/_/_/_/   _/_/_/_/   _/_/_/_/                  I use
   _/_/          _/_/       _/_/       _/_/               ORACLE v6.0.36.5.2
  _/_/          _/_/       _/_/       _/_/                        on        
 _/_/_/_/ .  _/_/_/_/ .   _/_/ .   _/_/_/_/ .            DEC RISC ULTRIX v4.3
------------------------------------------------------------------------------
Yves NOEL   -   Database Administrator
C.I.T.I. (batiment M4)                             Phone : (33)  20.43.42.70
Universite des Sciences & Technologies de Lille    Fax   : (33)  20.43.66.25 
59655 Villeneuve d'Ascq Cedex - FRANCE             Email : noel_at_univ-lille1.fr
------------------------------------------------------------------------------
Received on Wed Oct 13 1993 - 09:15:10 CET

Original text of this message