In a STATSPACK Report we see a lot of DB-Time and elapsed time for statements in the module APEX Listener.
Given the top 5 statements of a snapshot for 15' below, we notice
1****) there are about 640 Page Requests (which corresponds to the monitoring of Apex itself, so that seems ok)
2****) .. 5****): there are a about 2000 other statements issued by Apex per one Page Request (259,225 + 305,786 + 281,029 + 281,121) / 638
These secondary statements sum up to a Elapsed Time of about 600" per 15', which gives a considerable load on the DB-Server (Actually, APEX is the biggest load on this DB-Server, though there is running a OLTP Application as well).
Are the execution count of the secondary Statements 2****) .. 5****) a bug, or is there an explanation for such high execution counts ?
-----------------------------------------------------------------------------------------
SQL ordered by CPU DB/Inst: IBA/iba Snaps: 25287-25297
-> Total DB CPU (s): 3,329
-> Captured SQL accounts for 27.0% of Total DB CPU
-> SQL reported below exceeded 1.0% of Total DB CPU
CPU CPU per Elapsd Old
Time (s) Executions Exec (s) %Total Time (s) Buffer Gets Hash Value
---------- ------------ ---------- ------ ---------- --------------- ----------
304.33 638 1****) 0.48 9.1 360.42 22,740,202 922813023
Module: APEX Listener
begin f(p=>:1 ); commit; end;
280.66 259,225 2****) 0.00 8.4 401.62 54,541,517 4091782418
Module: APEX Listener
SELECT ( SELECT 'USER' FROM SYS.ALL_USERS WHERE USERNAME = :B1 U
NION ALL SELECT 'ROLE' FROM SYS.DBA_ROLES WHERE ROLE = :B1 ) FRO
M SYS.DUAL
71.84 305,786 3****) 0.00 2.2 86.38 2,189,013 2667322177
Module: APEX Listener
SELECT /*+ result_cache */ ID, ALIAS, OWNER, NAME, CHARSET, WEBD
B_LOGGING, FLOW_LANGUAGE, FLOW_LANGUAGE_DERIVED_FROM, DATE_FORMA
T, DATE_TIME_FORMAT, TIMESTAMP_FORMAT, TIMESTAMP_TZ_FORMAT, NLS_
SORT, NLS_COMP, FLOW_IMAGE_PREFIX, AUTHENTICATION, LOGOUT_URL, P
57.30 281,029 4****) 0.00 1.7 67.37 2,521,822 4095312686
Module: APEX Listener
SELECT /*+ result_cache */ CASE WHEN IS_DEFAULT = 'Y' THEN -1 EL
SE DISPLAY_SEQ END AS DISPLAY_SEQ, HOME_URL, LOGIN_URL, THEME_ID
, GLOBAL_PAGE_ID, CONTENT_DELIVERY_NETWORK, JAVASCRIPT_FILE_URLS
, INCLUDE_LEGACY_JAVASCRIPT, INCLUDE_JQUERY_MIGRATE, CSS_FILE_UR
53.17 281,121 5****) 0.00 1.6 64.21 1,338,441 2760518003
Module: APEX Listener
SELECT /*+ result_cache */ SHORTCUT_NAME, ID FROM WWV_FLOW_SHORT
CUTS WHERE FLOW_ID = :B3 AND (BUILD_OPTION IS NULL OR (BUILD_OPT
ION > 0 AND (:B2 IS NULL OR INSTR(:B2 ,':'||TO_CHAR(BUILD_OPTION
)||':') = 0) ) OR (BUILD_OPTION < 0 AND (:B1 IS NOT NULL AND INS