Re: tracking down hidden SQL???
From: Adric Norris <landstander668_at_gmail.com>
Date: Mon, 21 Oct 2013 08:46:06 -0500
Message-ID: <CAJueESq2uX_DivU=3OL=Om7Ogz78MJiz+R18_P8XNQKfBSDSng_at_mail.gmail.com>
On Thu, Oct 17, 2013 at 11:11 AM, Kerry Osborne <kerry.osborne_at_enkitec.com>wrote:
> V$OPEN_CURSOR hides some stuff. (as is the case with many of the v$
> views) Try going after the underlying x$ (x$kgllk). I answered your
> question on my blog as well with a little more detail, but that may allow
> you to see what's happening.
>
Date: Mon, 21 Oct 2013 08:46:06 -0500
Message-ID: <CAJueESq2uX_DivU=3OL=Om7Ogz78MJiz+R18_P8XNQKfBSDSng_at_mail.gmail.com>
On Thu, Oct 17, 2013 at 11:11 AM, Kerry Osborne <kerry.osborne_at_enkitec.com>wrote:
> V$OPEN_CURSOR hides some stuff. (as is the case with many of the v$
> views) Try going after the underlying x$ (x$kgllk). I answered your
> question on my blog as well with a little more detail, but that may allow
> you to see what's happening.
>
Interestingly, I'm not able to find the SQL ID in x$kgllk even with all filtering removed. That was, however, an excellent suggestion.
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Oct 21 2013 - 15:46:06 CEST