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>
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