Re: DBA_HIST_SQLSTAT

From: rjamya <rjamya_at_gmail.com>
Date: Tue, 20 Nov 2012 12:01:06 -0500
Message-ID: <CAGurbTPvspsJWPy=NLxLsAhBfkTH3KgBBmm=K0R34teZFkzPmQ_at_mail.gmail.com>

Chris, executions_total column is cumulative, executions_delta column is for the duration of that snap. Not sure what you are trying to do. If you can explain, perhaps I can come up with something . Raj

On Tue, Nov 20, 2012 at 11:05 AM, <Christopher.Taylor2_at_parallon.net> wrote:

> I'm wanting to look over a period – so if they're cumulative I really want
> the last value in the set using a row_Number() analytic function it would
> seem.****
>
> ** **
>
> I saw that Karl Arao had some scripts to do this sort of thing but I
> can't get to his scripts repository from work LOL****
>
> ** **
>
> Chris****
>
> ** **
>
> *From:* rjamya [mailto:rjamya_at_gmail.com]
> *Sent:* Tuesday, November 20, 2012 10:02 AM
> *To:* Taylor Christopher - Nashville
> *Cc:* ORACLE-L
> *Subject:* Re: DBA_HIST_SQLSTAT****
>
> ** **
>
> if you want to see per snap, then look at delta columns, ... the total
> columns are cumulative, more here
> http://docs.oracle.com/cd/E11882_01/server.112/e25513/statviews_4052.htm#I1023447
> ****
>
> ** **
>
> Raj****
>
> ** **
>

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

Received on Tue Nov 20 2012 - 18:01:06 CET