Re: Where does GC grab historical SQL plans from?
- From: Sriram Kumar <k.sriramkumar@xxxxxxxxx>
- To: rjoralist2@xxxxxxxxxxxxxxxxxxxxx
- Date: Fri, 20 May 2011 14:52:37 +0300
Hi ,
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@xxxxxxxxxxxxxxxxxxxxx> 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
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
