Re: explain plan, can you explain this?
Date: Fri, 11 Jan 2008 10:36:48 -0600
yes, I realized that a few minutes ago. reporting v stored.
On Jan 11, 2008 10:34 AM, Allen, Brandon <Brandon.Allen_at_oneneck.com> wrote:
> Andrew, the instances you've seen are normal. I think there is just some
> confusion here about exactly what we're all trying to say so I'll try to
> Yes, the statistics values stored in statspack and awr snapshots are *
> cumulative*, however the values reported by spreport.sql and awrrpt.sql(or by the "View Report" action under Snapshots in OEM) are the
> *deltas* calculated as the difference between those cumulative values for
> the specified begin and end snapshots.
> For example, at snap #1, we have accumulated 100 phyrds and at snap #10 we
> have accumulated 1000 phyrds, so when we run spreport or awrrpt and specify
> beginning snapshot #1 and end snapshot #10, it calculates the delta
> as 1000-100=900 and reports that 900 phyrds occurred during the interval
> between whatever time snapshots 1 and 10 were taken.
> Hopefully that makes sense and settles the issue so we can all get along
> now and enjoy our weekend :-)
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Andrew Kerber
> well, unless I have run into 3 really strange instances, it looks like
> cumulative values to me. Unless you can explain why the phyrds and phywrts
> are higher for each snap than the previous one for every file in my
> 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.
-- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.' -- http://www.freelists.org/webpage/oracle-lReceived on Fri Jan 11 2008 - 10:36:48 CST