Re: Oracle Rac-question

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

SELECT *
FROM gv_$session
WHERE sid = (SELECT DISTINCT sid FROM v_$mystat);

is one way.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)