RE: parsing puzzle
- From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- To: "jwc7744@xxxxxxxxx" <jwc7744@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 9 Apr 2010 09:31:53 -0700
My recommendation would be to scratch all your assumptions/guesses at this
point and start over with Method-R.
http://method-r.com/faq/31-method-r/35-what-is-method-r
More specifically, I'd focus on minimizing your top wait events from a 10046
trace of your most business-critical functions that are suffering from
performance problems. I'd also take a look at your top wait events from
AWR/statspack, but keep in mind they are more likely to be misleading. You
might also want to have a look at the current tools available from My Oracle
Support for analyzing your 10046 files and query performance (trace analyzer
and sqltxplain).
No, I don't work for the Method R company, and am not suggesting you purchase
anything. I'm just a firm believer in the Method R strategy for performance
tuning as it has worked well for me countless times over the years.
Regards,
Brandon
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Joe A-C
We have an application that is suddenly doing a lot of parsing. The history
behind this . . .
Privileged/Confidential Information may be contained in this message or
attachments hereto. Please advise immediately if you or your employer do not
consent to Internet email for messages of this kind. Opinions, conclusions and
other information in this message that do not relate to the official business
of this company shall be understood as neither given nor endorsed by it.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
