Monthly Archives: April 2014

Useful stuff from event 10053 traces – part 2

I would like to reflect once more on the “dynamic sampling used for this statement” message.¬†Suppose dynamic sampling really happened with reason, because statistics were old, missing or otherwise insufficient. Now what?   Dynamic sampling because of¬†missing or old statistics … Continue reading

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

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

Dynamic sampling NOT used for this statement?

So I’m still working on this data warehousing project and performance is not quite optimal. There are all kinds of things to be investigated. One thing I want to find, is the reason why a lot of execution plans show … Continue reading

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