what data do I trust?
From: Henry Poras <henry.poras_at_gmail.com>
Date: Fri, 2 Oct 2020 10:04:50 -0400
Message-ID: <CAK5zhL+KJBrjCT8XdKVqmLWLMEs3zZ2faWrotwdPQNfroOZq5w_at_mail.gmail.com>
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???
Date: Fri, 2 Oct 2020 10:04:50 -0400
Message-ID: <CAK5zhL+KJBrjCT8XdKVqmLWLMEs3zZ2faWrotwdPQNfroOZq5w_at_mail.gmail.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Oct 02 2020 - 16:04:50 CEST