Re: Unable to find SQL executed by blocking session

From: Stephane Faroult <sfaroult_at_roughsea.com>
Date: Fri, 15 Oct 2004 18:09:45 +0200
Message-Id: <200410151609.i9FG9jvL005068@webmail.nexlink.net>

Just done a test (on Solaris), text correctly found. Only snag is of course with dba_waiters, dba_blockers and the like which are still built upon the V$views.

May be an implementation issue.

Regards,

Stephane Faroult

RoughSea Ltd
http://www.roughsea.com

On Fri, 15 Oct 2004 11:35 , rjamya <rjamya_at_gmail.com> sent:

GV$ ... always.

Raj

On Fri, 15 Oct 2004 17:44:33 +0200, Stephane Faroult <sfaroult_at_roughsea.com[1]> wrote:
>
>
>Raj,
>
>Might it be that your sessions are attached to different instances? What
>are you checking? V$ or GV$ views ?
>
>Regards,
>
>Stephane Faroult
>
>RoughSea Ltd
>http://www.roughsea.com[2]

--
http://www.freelists.org/webpage/oracle-l[3]



--- Links ---
   1 javascript:parent.opencompose('sfaroult_at_roughsea.com','','','')
   2 modules/refer.pl?redirect=http%3A%2F%2Fwww.roughsea.com
   3 modules/refer.pl?redirect=http%3A%2F%2Fwww.freelists.org%2Fwebpage%2Foracle-l
--
http://www.freelists.org/webpage/oracle-l

Received on Fri Oct 15 2004 - 10:55:05 CDT