Tag Archives: optimizer

Useful stuff from event 10053 traces – part 1

In theory you can use event 10053 traces to see what choices the optimizer has made, which is very interesting if your query didn’t perform as it was supposed to do. In practice event 10053 traces contain an overwhelming amount … Continue reading

Posted in Oracle performance tuning | Tagged , , , , , , , , | Leave a comment

More statistics history

After writing about table statistics, I tried my query to retrieve them many times. Soon I found out, I couldn’t find index statistics data. After a while I figured it out. Duh! The table is called WRI$_OPTSTAT_TAB_HISTORY. So I quickly … Continue reading

Posted in Oracle performance tuning, Oracle scripts | Tagged , , , , , | Leave a comment