Re: high cpu on query

Don't forget SQL profiles... maybe those were lumped in with stored outlines though. This could be a useful list - is there anything else or is this it?

1. change in text of sql (including hints)
2. change in init or session params
3. change in object stats (tables stats or index stats, also histograms)
4. change in system stats
5. Change in schema (create/drop indexes, partition/cluster/parallelism declarations, etc.)
6. Stored outline or SQL profile manipulation
7. Oracle CBO code change (e.g., upgrade or patch)

On 6/29/07, Cary Millsap <cary.millsap_at_hotsos.com> wrote:
>
> Some more for the list:
>
> 5) Change in schema (create/drop indexes, histograms,
> partition/cluster/parallelism declarations, etc.)
>
> 6) Stored outline manipulation
>
> 7) Oracle CBO code change (e.g., upgrade)
>
>
>
> *Cary** Millsap*
>
> Hotsos Enterprises, Ltd.
>
> http://www.hotsos.com
>
> *Nullius in verba*
>
>
>
> Hotsos Symposium 2008 / March 2–6 / Dallas
>
> Visit www.hotsos.com for curriculum and schedule details...
> ------------------------------
>

-- 
Jeremy Schneider
Chicago, IL
http://www.ardentperf.com/category/technical
--
http://www.freelists.org/webpage/oracle-l