Thanks, works as advertised
Jay
----- Original Message -----
From: "Steven Baldwin" <[EMAIL PROTECTED]>
To: "Jay Strauss" <[EMAIL PROTECTED]>; "[EMAIL PROTECTED]"
<[EMAIL PROTECTED]>
Sent: Monday, September 10, 2001 7:41 PM
Subject: RE: This connection with DBD::Oracle
> 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
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
