Connor McDonald writes that It’s just bad code or bad design … most of the time for Oracle performance problems.
I have spent the past year doing performance modelling of a new product that is being rolled progressively to clients. The most frustrating thing has the lack of meaningful feedback from the product support group. Everytime I raise a concern that the performance is not as expected, I get the platitude that the product is performing as expected.
I have recently used SQLTXPLAIN to solve a production performance issue. This post is about my experiences with this tool.
We have been experiencing performance problems after upgrading to Oracle RDBMS 18.104.22.168 and 22.214.171.124 due to high Direct Path Read events. This post is a selection of MOS documents that could be relevant to our problems.
Today I learnt something new about Oracle 11.2. I found an interesting MOS document: How to Obtain Tracing of Optimizer Computations (EVENT 10053) (Doc ID 225598.1).