Re: Querying awr to hunt down source of sql executions
- From: Tanel Poder <tanel@xxxxxxxxxxxxxx>
- To: "Stephens, Chris" <Chris.Stephens@xxxxxxx>
- Date: Wed, 2 Mar 2011 19:41:29 +0200
Hi,
V$SQL% views show only SQL cursors and anonymous PL/SQL cursors, but no
other objects, you'll need to query X$KGLOB directly (SQL_ID was KGLOBT03 or
T13 column IIRC).
--
Tanel Poder
Oracle Troubleshooting Blog - http://blog.tanelpoder.com
Online Troubleshooting Seminars -
http://tech.e2sn.com/oracle-training-seminars
On Wed, Mar 2, 2011 at 6:55 PM, Stephens, Chris <Chris.Stephens@xxxxxxx>wrote:
> Possibly this falls into the ‘bugs or design limitations’ since I don’t
> see anything in any of the v$sql* views with that particular module/sql_id.
> I’ll keep an eye on the v$sql* views and incoming snapshots to see if
> possibly the sql just isn’t in the shared pool at the moment.
>
>
>
> This definitely sheds some light on my understanding of awr though.
> Thanks!
>
>
>
Other related posts:
