Re: what data do I trust?

Hi Henry,

So, yes, your query started in snap #35477 and took 2647 seconds, but finished in snap #35478 (another 2741 seconds), so whole executions tool 5388 seconds.

>Does this just mean that the child cursor was aged out of v$sql, and when
it was first loaded (executions_total goes from 0 to 1) it was too lightweight to be captured in dba_hist_sqlstat?

yes, absolutely correct

On Fri, Oct 2, 2020 at 6:51 PM Henry Poras <henry.poras_at_gmail.com> wrote:

>
> SNAP_ID PLAN_HASH_VALUE EXECUTIONS_TOTAL EXECUTIONS_DELTA
> ELAPSED_TIME_TOTAL ELAPSED_TIME_DELTA VERSION_COUNT
> ---------- --------------- ---------------- ----------------
> ------------------ ------------------ -------------
> 35477 327755044 2 0
> 1,301,726,321 0 16
> 878986732 0 0
> 2,647,242,771 2,647,242,771 16
>
> 35478 327755044 2 0
> 1,301,726,321 0 16
> 878986732 1 1
> 5,388,766,867 2,741,524,096 16
>
>

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

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