Brandon, Thanks for the recommendation about method-r. I have heard lots of good things about it. I've been using the AWR reports but I'll check out the tools on MOS. According to the AWR reports, the top 3 waits are always "latch: library cache", "latch: shared pool" and CPU. The Parse CPU to Parse Elapsd Percentage is always very low, usually from 0 to 8%. Sounds to me like it's parsing due to literals. Why do you say that the AWR reports are likely to be misleading? Thanks. --- On Fri, 4/9/10, Allen, Brandon <Brandon.Allen@xxxxxxxxxxx> wrote: > From: Allen, Brandon <Brandon.Allen@xxxxxxxxxxx> > Subject: RE: parsing puzzle > To: "jwc7744@xxxxxxxxx" <jwc7744@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" > <oracle-l@xxxxxxxxxxxxx> > Date: Friday, April 9, 2010, 12:31 PM > 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