RE: parsing puzzle

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_at_OneNeck.com> wrote:

> From: Allen, Brandon <Brandon.Allen_at_OneNeck.com>
> Subject: RE: parsing puzzle
> To: "jwc7744_at_yahoo.com" <jwc7744_at_yahoo.com>, "oracle-l_at_freelists.org" <oracle-l_at_freelists.org>
> 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_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]
> 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.
>
      

--
http://www.freelists.org/webpage/oracle-l