Re: Where does GC grab historical SQL plans from?
From: Marcin Przepiorowski <pioro1_at_gmail.com>
Date: Fri, 13 May 2011 09:42:47 +0100
Message-ID: <BANLkTikvOGmbE7JRcer+MuaoM-thQ=X8qQ_at_mail.gmail.com>
On Thu, May 12, 2011 at 2:55 PM, Rich Jesse <rjoralist2_at_society.servebeer.com> wrote:
>
> Thoughts on where GC grabs SQL history from? DBA_HIST_SQL_PLAN on the
> target DB is oddly devoid of this particular SQL.
>
Date: Fri, 13 May 2011 09:42:47 +0100
Message-ID: <BANLkTikvOGmbE7JRcer+MuaoM-thQ=X8qQ_at_mail.gmail.com>
On Thu, May 12, 2011 at 2:55 PM, Rich Jesse <rjoralist2_at_society.servebeer.com> 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 -- http://www.freelists.org/webpage/oracle-lReceived on Fri May 13 2011 - 03:42:47 CDT