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@xxxxxxxxxx> 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

Other related posts: