Re: tracking down hidden SQL???
- From: Adric Norris <landstander668@xxxxxxxxx>
- To: Kerry Osborne <kerry.osborne@xxxxxxxxxxx>
- Date: Mon, 21 Oct 2013 08:46:06 -0500
On Thu, Oct 17, 2013 at 11:11 AM, Kerry Osborne
<kerry.osborne@xxxxxxxxxxx>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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
