A little while ago I wrote a note about an anomaly that someone was seeing with the index_ss() hint. Since then, they forwarded me a 10053 trace file of the question.
I’ve posted brief analysis of it on my website, just to give you an idea of the sorts of things you can look out for when you’re trying to work out why Oracle seems to be ignoring a hint.
need to understand event 10053
Comment by Abhay — February 8, 2007 @ 7:05 am UTC Feb 8,2007 |
Abhay: Metalink has some notes, search for 10053 under the “Knowledge Base” area. The first item will (probably) be: this one which leads on to the case study
For other assistance from the internet check Wolfgang Breitling’s paper (pdf)
You could also get my book, which has a sample walkthrough of a 4-table join in chapter 14.
Be aware of this comment from the Oracle pages though: “The 10053 is typically not the best place to start looking for tuning opportunities – the execution plan and TKProf have better information in this regard”
Comment by Jonathan Lewis — February 8, 2007 @ 10:36 am UTC Feb 8,2007 |