How about:
select
s.username,
s.sid
from v$session s
where userenv('SESSIONID') = s.audsid
/
??
Jared
Post, Ethan
Ethan, is this the SID you want?
Boy, was I way off! I thought you meant Oracle_Sid!
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Tuesday, October 02, 2001 3:56 PM
To: Multiple recipients of list ORACLE-L
How about:
select
s.username,
s.sid
from
Ethan,
I'm not sure what you mean by SID.
Do you mean an environmental like ORACLE_SID?
On NT, this does not exist unless you create it by
issuing 'set oracle_sid=prod'.
Similiar thing on Unix, I think.
Internally (in Oracle), you can check things like v$database, v$instance,
even