Method R Discussion GroupMethod R helps developers, DBAs, and decision-makers optimize Oracle-based software in every phase of the software life cycle. |
|
Discuss Method R products, techniques, and events. Ask new questions or post your own responses. |
10046. The first step of "tuning" is to find out where your time has gone. It's not always the SQL. It's often not.
Five minutes ago, I was asked to look at someone's new performance problem situation. In this situation, there actually was some really bad SQL, but 90.8% of the task's 1,490-second response time was time consumed BETWEEN executions of those really bad SQL statements. (The problem here is that the application makes too many OCIStmtPrepare calls.) I couldn't have found this out by looking at anything other than 10046 data first. Once your 10046 data has told you that a SQL statement's execution has contributed materially to your total response time, THAT's when you drill into the 10053 data. |
Powered by FogBugz