Re: Oracle Rac-question

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 24 Nov 2005 08:58:30 +0100
Message-ID: <hhsao1dpjmisnokan3v7a1li1cg90gueid@4ax.com>

On 23 Nov 2005 23:19:10 -0800, ohahaahr_at_hotmail.com wrote:

>Next question !
>
>How do i know, which record in gv$session is mine ??
>
>My users login through a front-end, which all uses the same
>oracle-username. Therefore i cannot use the username to find 'my'
>session.
>
>Select * from gv$session where ??????????????
>
>Regards,
>Ole

audsid = userenv('sessionid') should still work. Questions like this are better looked up (will be faster) using the description of the gv$session view in the Reference manual at http://tahiti.oracle.com
Be prepared for nasty responses if you continue to ask them here.

--
Sybrand Bakker, Senior Oracle DBA

Received on Thu Nov 24 2005 - 01:58:30 CST