Try this ...
select * from v$session where audsid = userenv ('sessionid')
Steve
-----Original Message-----
From: Jay Strauss [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 11 September 2001 10:38 AM
To: [EMAIL PROTECTED]
Subject: This connection with DBD::Oracle
Hi,
Is there any attribute(s) of the database handle that identify the sid and
serial# of the connection? That is, I want to use DBI to kill some sessions
(but I don't want to kill myself).
Or is there a table/view like dual that contains this session's information?
I can probably find my current session by selecting from v$session using a
combination of username, logon_time, type, program... but it seems
inelegant.
Thanks
Jay
Jay Strauss
[EMAIL PROTECTED]
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
