RE: parsing puzzle
- From: Joe A-C <jwc7744@xxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>, BrandonAllen <Brandon.Allen@xxxxxxxxxxx>
- Date: Fri, 9 Apr 2010 12:14:04 -0700 (PDT)
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
Other related posts:
