Re: explain plan, can you explain this?

yes, I realized that a few minutes ago.  reporting v stored.

On Jan 11, 2008 10:34 AM, Allen, Brandon <Brandon.Allen@xxxxxxxxxxx> 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
> clarify:
>
> 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 :-)
>
> Regards,
> Brandon
>
>  ------------------------------
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *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
> instance.
>
> 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.'

Other related posts: