SQL Performance (MOSC)

MOSC Banner

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);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center