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! > > >