executions in v$sql are much more than real executions
Hi all,
we are in 12.1 oracle database version
for different statements we see that there are lots of executions despite of the real application calls
SQL> select PARSING_SCHEMA_NAME,executions_delta HOUR_EXECS,executions_delta/12 "5MIN_EXECS" from dba_hist_sqlstat where sql_id='6913jzna926xs' and snap_id=31913;
PARSING_SCHEMA_NAME: RTPRM_CLIENT
HOUR_EXECS: 4135778
5MIN_EXECS: 344648.167
SQL> SELECT COUNT(*) as "5MIN_APP_EXECS" FROM RTPRM_CLIENT.RT_SHORTWINDOW WHERE DD_APDATE BETWEEN TO_DATE('20210809093000','YYYYMMDDHH24MISS') AND TO_DATE('20210809093600','YYYYMMDDHH24MISS') AND DD_PARTITION_DATE=TRUNC(SYSDATE);
5MIN_APP_EXECS
--------------
20469
SQL> SELECT COUNT(*) HOUR_APP_EXECS FROM RTPRM_CLIENT.RT_SHORTWINDOW WHERE DD_APDATE BETWEEN TO_DATE('20210809090000','YYYYMMDDHH24MISS') AND TO_DATE('20210809100000','YYYYMMDDHH24MISS') AND DD_PARTITION_DATE=TRUNC(SYSDATE);