Oracle Point, Oracle Life.

I just read a AskTom thread about event 10053. As we known, event 10053 is used to trace CBO choices. In this posting, Tom explains couple of unclear issues about trace file with event 10053.

They are:

• How CBO works and what impacts CBO in determining execution plan?
• undocumented parameters is strongly required to be NOT changed without official guidance
• use cardinality of table to diagnosis query problem
• explanation of what the abbreviations mean in trace file
• the process of sample case diagonisis
• Tom’s recommendation with using event 10053

The original posting is available at http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:63445044804318

Popularity: 3% [?]

This is summary list of my postings on topic “Tunning SGA % PGA with scripts”.

• Tuning SGA with scripts (Part 1) - Tuning Data Buffers
• Tuning SGA with scripts (Part 2) - Tuning Shared Pool
• Tuning SGA with scripts (Part 3) - Library Cache
• Tuning SGA with scripts (Part 4) - Redo Log Buffer
• Tuning SGA with scripts (Part 5) - Large Pool
• Tuning PGA $ UGA with scripts

Popularity: 3% [?]