Re: what data do I trust?

  Hi Henry,

Have you checked executions_total and elapsed_time_total? Looks like it accounted 2742 sec in current snapshot and 5389-2742 sec (2647) in previous snapshot

On Fri, Oct 2, 2020 at 5:12 PM <niall.litchfield_at_gmail.com> wrote:

> I don't know this, but feel I once did, does a rolled back execution not
> count to the dba_hist cpu and elapsed totals.? Should be possible to test
> this.
>
> On Fri, Oct 2, 2020 at 3:06 PM Henry Poras <henry.poras_at_gmail.com> wrote:
>
>> I'm seeing a discrepancy between some data in an AWR report and
>> dba_hist_sqlstat (v 12.1). Hoping someone can help (I hate it when I don't
>> know what data to believe). It looks like the AWR is roughly doubling a
>> bunch of the values. AWR show 1 execution, elapsed time (and elapsed time
>> per sec) = 5389 sec, cpu time = 62, while
>> dba_hist_sqlstat.executions_delta=1, elapsed_time_delta=> 2742 sec,
>> cpu_time_delta=>30 sec. There is no entry for this sql_id in the previous
>> or following snap_id. Any ideas???
>>
>> Thanks.
>>
>> Henry
>>
>>
>>
>>
>
> --
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info
>

-- 
Best regards,
Sayan Malakshinov
Oracle performance tuning engineer
Oracle ACE Associate
http://orasql.org

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