Re: Where does GC grab historical SQL plans from?
- From: Marcin Przepiorowski <pioro1@xxxxxxxxx>
- To: rjoralist2@xxxxxxxxxxxxxxxxxxxxx
- Date: Fri, 13 May 2011 09:42:47 +0100
On Thu, May 12, 2011 at 2:55 PM, Rich Jesse
<rjoralist2@xxxxxxxxxxxxxxxxxxxxx> wrote:
>
> Thoughts on where GC grabs SQL history from? DBA_HIST_SQL_PLAN on the
> target DB is oddly devoid of this particular SQL.
>
GC is using Database AWR repository - DBA_HIST_ tables.
How often are you doing AWR snapshots ? Can you see that query in real
time mode ?
regards,
--
Marcin Przepiorowski
http://oracleprof.blogspot.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
