Re: parsing puzzle
- From: Joe A-C <jwc7744@xxxxxxxxx>
- To: Cary Millsap <cary.millsap@xxxxxxxxxxxx>
- Date: Fri, 9 Apr 2010 17:27:32 -0700 (PDT)
Cary and Branden,
I take your point and appreciate the insights.
Thanks.
--- On Fri, 4/9/10, Cary Millsap <cary.millsap@xxxxxxxxxxxx> wrote:
From: Cary Millsap <cary.millsap@xxxxxxxxxxxx>
Subject: Re: parsing puzzle
To: "Joe A-C" <jwc7744@xxxxxxxxx>
Cc: Brandon.Allen@xxxxxxxxxxx, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
Date: Friday, April 9, 2010, 5:45 PM
...And my point is that even if your system consistently reports the same "wait
events" being your dominant response time consumers, it doesn't mean that these
wait events are the problem for the specific business task you're hoping to
make faster. See
http://www.oreillynet.com/pub/a/network/excerpt/optimizing_oracle_chap12/ for a
real-life example.
In your case, I jumped all over the parsing and latching issues (actually, I
jumped on the parsing issue; I only guessed the latching issue) because it's a
subject I'm interested in. But prioritizing what you tune first based on what
you're interested in, or what you guess the problem probably is, ...that's no
way to do it. You don't need to guess, because you can know. If you base your
diagnosis on AWR/Statspack, then there's still an element of guessing involved.
...As I think you'll understand if you read the example I provided.
Cary Millsap
Method R Corporation
http://method-r.com
On Fri, Apr 9, 2010 at 4:32 PM, Allen, Brandon <Brandon.Allen@xxxxxxxxxxx>
wrote:
Just to clarify, I’m not saying that your AWR reports
are misleading you or that AWR/Statspack reports are “bad” in general – I use
them regularly myself and often find them to be very useful. They might even
be pointing you in the right direction here. I was simply trying to caution
you that they
can be misleading. I only skimmed your original post this morning and can’t
remember the specifics and am too busy to review it, but from the quick glance
I gave it, it just looked to me like you
might have been making some invalid assumptions that could be leading you off
track so I was merely recommending how I would approach the issue in general,
not even addressing your main questions, which I believe were about parsing and
latching issues.
Regards,
Brandon
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.
Other related posts:
