Re: How to find SID?

In article <31F669FE.4487EB71_at_csd.eds.com>, Chandra Kamalakantha 604-1291 <ckamal01_at_csd.eds.com> writes:
> Che wrote:
> >
> > How can you find the oracle database you are connected to once you are
> > connected? I've got the userid but need to the database to later perform
> > an OP$ login back into oracle.
> > - Che

As sys try the following

select * from ora_sid;
SELECT KSQDNGDN FROM X$KSQDN;
SELECT VALUE FROM V$PARAMETER WHERE name='db_name'; SELECT * FROM V$DATABASE;
select * from global_name;

-- 
 _____       ________ / ___|Tony Jambu, Database and Oracle WebSys Consultant
  /_  _        /_ __ /     |Wizard Consulting,Aust (ACN 065934778)
 /(_)/ )(_/ \_/(///(/_)/_( |CIS: 100250.2003_at_compuserve.com FAX:+61-3-94163559
 \_______/                 |EMAIL:TJambu_at_wizard.com.au PHONE:+61-3-94122905