Vito did more testing and found more repo table queries that cause mxosrvr cores:
select EXEC_START_UTC_TS,QUERY_ID,USER_NAME,QUERY_TEXT from TRAFODION."_REPOS_".METRIC_QUERY_TABLE;
select EXEC_START_UTC_TS,QUERY_ID,USER_NAME,EXPLAIN_PLAN from TRAFODION."_REPOS_".METRIC_QUERY_TABLE;
select EXEC_START_UTC_TS,QUERY_ID,ROLE_NAME,QUERY_TEXT from TRAFODION."_REPOS_".METRIC_QUERY_TABLE;
select EXEC_START_UTC_TS,QUERY_ID,ROLE_NAME,EXPLAIN_PLAN from TRAFODION."_REPOS_".METRIC_QUERY_TABLE;
select EXEC_START_UTC_TS,QUERY_ID,SESSION_ID,QUERY_TEXT from TRAFODION."_REPOS_".METRIC_QUERY_TABLE;
select EXEC_START_UTC_TS,QUERY_ID,SESSION_ID,EXPLAIN_PLAN from TRAFODION."_REPOS_".METRIC_QUERY_TABLE;
select EXEC_START_UTC_TS,QUERY_ID,STATEMENT_ID,QUERY_TEXT from TRAFODION."_REPOS_".METRIC_QUERY_TABLE;
select EXEC_START_UTC_TS,QUERY_ID,STATEMENT_ID,EXPLAIN_PLAN from TRAFODION."_REPOS_".METRIC_QUERY_TABLE;
select EXEC_START_UTC_TS,QUERY_ID,STATEMENT_TYPE,QUERY_TEXT from TRAFODION."_REPOS_".METRIC_QUERY_TABLE;
select EXEC_START_UTC_TS,QUERY_ID,STATEMENT_TYPE,EXPLAIN_PLAN from TRAFODION."_REPOS_".METRIC_QUERY_TABLE;
select EXEC_START_UTC_TS,QUERY_ID,STATEMENT_SUBTYPE,QUERY_TEXT from TRAFODION."_REPOS_".METRIC_QUERY_TABLE;
select EXEC_START_UTC_TS,QUERY_ID,STATEMENT_SUBTYPE,EXPLAIN_PLAN from TRAFODION."_REPOS_".METRIC_QUERY_TABLE;
select EXEC_START_UTC_TS,QUERY_ID,QUERY_STATUS,QUERY_TEXT from TRAFODION."_REPOS_".METRIC_QUERY_TABLE;
select EXEC_START_UTC_TS,QUERY_ID,QUERY_SUB_STATUS,QUERY_TEXT from TRAFODION."_REPOS_".METRIC_QUERY_TABLE;
Vito did more testing and found more repo table queries that cause mxosrvr cores:
select EXEC_START_ UTC_TS, QUERY_ID, USER_NAME, QUERY_TEXT from TRAFODION. "_REPOS_ ".METRIC_ QUERY_TABLE; UTC_TS, QUERY_ID, USER_NAME, EXPLAIN_ PLAN from TRAFODION. "_REPOS_ ".METRIC_ QUERY_TABLE; UTC_TS, QUERY_ID, ROLE_NAME, QUERY_TEXT from TRAFODION. "_REPOS_ ".METRIC_ QUERY_TABLE; UTC_TS, QUERY_ID, ROLE_NAME, EXPLAIN_ PLAN from TRAFODION. "_REPOS_ ".METRIC_ QUERY_TABLE; UTC_TS, QUERY_ID, SESSION_ ID,QUERY_ TEXT from TRAFODION. "_REPOS_ ".METRIC_ QUERY_TABLE; UTC_TS, QUERY_ID, SESSION_ ID,EXPLAIN_ PLAN from TRAFODION. "_REPOS_ ".METRIC_ QUERY_TABLE; UTC_TS, QUERY_ID, STATEMENT_ ID,QUERY_ TEXT from TRAFODION. "_REPOS_ ".METRIC_ QUERY_TABLE; UTC_TS, QUERY_ID, STATEMENT_ ID,EXPLAIN_ PLAN from TRAFODION. "_REPOS_ ".METRIC_ QUERY_TABLE; UTC_TS, QUERY_ID, STATEMENT_ TYPE,QUERY_ TEXT from TRAFODION. "_REPOS_ ".METRIC_ QUERY_TABLE; UTC_TS, QUERY_ID, STATEMENT_ TYPE,EXPLAIN_ PLAN from TRAFODION. "_REPOS_ ".METRIC_ QUERY_TABLE; UTC_TS, QUERY_ID, STATEMENT_ SUBTYPE, QUERY_TEXT from TRAFODION. "_REPOS_ ".METRIC_ QUERY_TABLE; UTC_TS, QUERY_ID, STATEMENT_ SUBTYPE, EXPLAIN_ PLAN from TRAFODION. "_REPOS_ ".METRIC_ QUERY_TABLE; UTC_TS, QUERY_ID, QUERY_STATUS, QUERY_TEXT from TRAFODION. "_REPOS_ ".METRIC_ QUERY_TABLE; UTC_TS, QUERY_ID, QUERY_SUB_ STATUS, QUERY_TEXT from TRAFODION. "_REPOS_ ".METRIC_ QUERY_TABLE;
select EXEC_START_
select EXEC_START_
select EXEC_START_
select EXEC_START_
select EXEC_START_
select EXEC_START_
select EXEC_START_
select EXEC_START_
select EXEC_START_
select EXEC_START_
select EXEC_START_
select EXEC_START_
select EXEC_START_