Tag Archives: dbms_stats

Tips for DBMS_STATS (Part 2/2)

The second part of this post includes taking statistics on partitioned objects and how aggregated statistics work. If you want more detail on DBMS_STATS go to the first part of this post, where you will find info on stale statistics … Continue reading

Posted in Oracle Server, Performance & Tuning | Tagged , , , , , , , | 15 Comments

Tips for DBMS_STATS (part 1/2)

Taking statistics and have them updated is a very important task on most Oracle databases, the CBO (Cost Based Optimizer) evaluates the cost of several Execution Paths, this cost is mainly based on physical and logical Disk IO, CPU use … Continue reading

Posted in Oracle Server, Performance & Tuning | Tagged , , , , | Leave a comment