Re: How can I determine who is currently logged in the Oracle server?
From: gazzag <gareth_at_jamms.org>
Date: Tue, 22 Sep 2009 01:53:11 -0700 (PDT)
Message-ID: <deba4543-9435-4425-9dfd-9cb103c5cc39_at_o36g2000vbl.googlegroups.com>
On 22 Sep, 07:18, Shakespeare <what..._at_xs4all.nl> wrote:
> In that case, Gazzag's answer will do. You can even make your
> intermediate server set its own program info to easily find it back in
> V$SESSION
>
> Shakespeare
Date: Tue, 22 Sep 2009 01:53:11 -0700 (PDT)
Message-ID: <deba4543-9435-4425-9dfd-9cb103c5cc39_at_o36g2000vbl.googlegroups.com>
On 22 Sep, 07:18, Shakespeare <what..._at_xs4all.nl> wrote:
> In that case, Gazzag's answer will do. You can even make your
> intermediate server set its own program info to easily find it back in
> V$SESSION
>
> Shakespeare
As per Shakespeare's suggestion, in conjunction with my V$SESSION query, look into DBMS_APPLICATION_INFO:
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_appinf.htm#CHECEIEB
HTH -g Received on Tue Sep 22 2009 - 03:53:11 CDT