AWR views

From: Rob Cowell <rjc4687_at_hotmail.com>
Date: Tue, 16 Oct 2007 07:11:33 -0700
Message-ID: <1192543893.306367.122590@e34g2000pro.googlegroups.com>

Can anyone point me at any documentation explaining how the AWR views are populated.

Specifically I'm querying DBA_HIST_SQL_PLAN looking to see what plans have been used for executed SQL.

I query sys.wrh$_sqltext to get the sql_id for sql I'm looking at. The information goes very quickly from v$sql, I'm not sure if there is a "better" view for find sql_id?

Then when I look in DBA_HIST_SQL_PLAN often the latest TIMESTAMP is for a couple of days ago even when I know the SQL was run recently.

So does v$sql_plan, and so DBA_HIST_SQL_PLAN only record a plan when SQL is hard parsed, which given my code goes from v$sql very quickly I'm assuming is happening? And does that information only get to DBA_HIST_SQL_PLAN as part of the AWR snapshot process?

And before anyone asks, it's Server Enterprise Edition 10.2.0.2 and I do have a full license for AWR.

Thanks Received on Tue Oct 16 2007 - 09:11:33 CDT