CREATE EVENT MONITOR STMT_USERDB FOR STATEMENTS
WHERE AUTH_ID='USERDB'
WRITE TO TABLE
  CONNHEADER (TABLE STMT_USERDB_CONN IN USERSPACE1)
, STMT (TABLE STMT_USERDB_STMT IN USERSPACE1);

SET EVENT MONITOR STMT_USERDB STATE 1;

-- .... подождать нужное время ....

SET EVENT MONITOR STMT_USERDB STATE 0;

SELECT "AGENT_ID", "AGENTS_TOP", "APPL_ID", "BLOCKING_CURSOR", 
    "CONSISTENCY_TOKEN", "CREATOR", "CURSOR_NAME", "EVMON_FLUSHES", 
    "FETCH_COUNT", "INT_ROWS_DELETED", "INT_ROWS_INSERTED", "INT_ROWS_UPDATED"
    , "PACKAGE_NAME", "PACKAGE_VERSION_ID", "PARTIAL_RECORD", 
    "POOL_DATA_L_READS", "POOL_DATA_P_READS", "POOL_INDEX_L_READS", 
    "POOL_INDEX_P_READS", "POOL_TEMP_DATA_L_READS", "POOL_TEMP_DATA_P_READS", 
    "POOL_TEMP_INDEX_L_READS", "POOL_TEMP_INDEX_P_READS", 
    "POOL_TEMP_XDA_L_READS", "POOL_TEMP_XDA_P_READS", "POOL_XDA_L_READS", 
    "POOL_XDA_P_READS", "ROWS_READ", "ROWS_WRITTEN", "SECTION_NUMBER", 
    "SEQUENCE_NO", "SORT_OVERFLOWS", "SQL_REQ_ID", "SQLCABC", "SQLCAID", 
    "SQLCODE", "SQLERRD1", "SQLERRD2", "SQLERRD3", "SQLERRD4", "SQLERRD5", 
    "SQLERRD6", "SQLERRM", "SQLERRP", "SQLSTATE", "SQLWARN", "START_TIME", 
    "STATS_FABRICATE_TIME", "STMT_OPERATION", "STMT_TYPE", "STOP_TIME", 
    "SYNC_RUNSTATS_TIME", "SYSTEM_CPU_TIME", "TOTAL_SORT_TIME", "TOTAL_SORTS",
    "USER_CPU_TIME", "STMT_TEXT"
  FROM "USERDB"."STMT_USERDB_STMT"
  INNER JOIN
  (SELECT "AGENT_ID" AID, "APPL_ID" APLID
  from "USERDB"."STMT_USERDB_CONN" WHERE TRIM("CLIENT_NNAME") = 'app_name_from_client') AS DRUMS
  ON DRUMS.AID="AGENT_ID" AND "APPL_ID" = DRUMS.APLID
  WHERE "STMT_TEXT" IS NOT NULL AND TRIM("STMT_TEXT")<>'';