Re: Where does GC grab historical SQL plans from?

One of the similar cases, we used dbms_workload_repository.add_colored_sql to capture the details of that specific sql_id even though it was not in the top SQL's. may be this could help you

best Regards

Sriram Kumar

On Thu, May 12, 2011 at 4:55 PM, Rich Jesse < rjoralist2_at_society.servebeer.com> wrote:

> Howdy,
>
> Having an issue this AM with a query and a very bad explain plan. It's odd
> that Grid Control's Top Activity can't seem to locate this SQL in history,
> considering 15+ folks are running it right now. I've had issues in the
> past
> where GC gets confused with two different plans in the GUI, so I'd like to
> query the data directly.
>
> Thoughts on where GC grabs SQL history from? DBA_HIST_SQL_PLAN on the
> target DB is oddly devoid of this particular SQL.
>
> And yes, we do have Tuning and Diag packs...
>
> TIA!
> Rich
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l