Re: Unable to find SQL executed by blocking session
- From: Stephane Faroult <sfaroult@xxxxxxxxxxxx>
- To: sfaroult@xxxxxxxxxxxx, Oracle Discussion List <oracle-l@xxxxxxxxxxxxx>, rjamya <rjamya@xxxxxxxxx>
- Date: Fri, 15 Oct 2004 18:09:45 +0200
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@xxxxxxxxx> sent:
GV$ ... always.
Raj
On Fri, 15 Oct 2004 17:44:33 +0200, Stephane Faroult
<sfaroult@xxxxxxxxxxxx[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]
--
//www.freelists.org/webpage/oracle-l[3]
--- Links ---
1 javascript:parent.opencompose('sfaroult@xxxxxxxxxxxx','','','')
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
