Re: How to find SID?

From: Naren Chintala <naren_at_mink.att.com>
Date: 1996/07/27
Message-ID: <4te00m$dkh_at_newsa.netnews.att.com>#1/1


dnoah_at_earthlink.net (Danial A. Noah) wrote:
>On 17 Jul 1996 00:55:24 GMT, Che <cdiggens_at_banda.NTU.EDU.AU> 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
>>
>
>
>query v$session

Oops, SID in v$session is the session identifier. Looks from Che question he wanted to know the value of ORACLE_SID. Received on Sat Jul 27 1996 - 00:00:00 CEST

Original text of this message