Oracle Tables That Are Error or Log Tables

Following is a list of the SQL commands for the Oracle tables that contain logging or error information for Millennium. Excluded from the 90+ tables are 1) the ESI_LOG table because it is typically large and managed by the purge job manager (DMPURGEJOBMGR.EXE) to keep its size limited and 2) other log tables that I could determine were for specific application functions and not for tracking application issues.

SELECT count(*) from activity_log

SELECT count(*) from ags_log

SELECT count(*) from at_log

SELECT count(*) from auth_error

SELECT count(*) from auth_error_detail

SELECT count(*) from batch_print_log

SELECT count(*) from bce_event_log

SELECT count(*) from bo_gen_event_log

SELECT count(*) from br_data_ops_log

SELECT count(*) from br_field_errors

SELECT count(*) from br_gen_event_log

SELECT count(*) from BR_RLI_CLIENT_LOG

SELECT count(*) from CCL_REF_LOGGING

SELECT count(*) from CCL_REF_LOGGING_BIND

SELECT count(*) from CDI_REJECT_LOG

SELECT count(*) from CDI_TRANS_LOG

SELECT count(*) from CE_AUDIT_LOG

SELECT count(*) from CHART_DIST_LOG

SELECT count(*) from CHART_REQ_INERR_EVENT

SELECT count(*) from CHART_SERV_LOG

SELECT count(*) from CKE_QUERYLOG

SELECT count(*) from CMT_IMPORT_LOG

SELECT count(*) from CMT_IMPORT_LOG_MSG

SELECT count(*) from CORSP_LOG

SELECT count(*) from CORSP_LOG_RELTN

SELECT count(*) from CPMPROCESS_ERROR

SELECT count(*) from CQM_MDRESULTS_LOG

SELECT count(*) from CQM_MICRESULTS_LOG

SELECT count(*) from CQM_OENTXLOG_QUE

SELECT count(*) from CS_CPP_ERROR_LOG

SELECT count(*) from CSI_ERROR_LOG

SELECT count(*) from CSI_LOG

SELECT count(*) from DCP_ACTIVITY_LOG

SELECT count(*) from DCP_ERROR_LOG

SELECT count(*) from DISPENSE_STATUS_ERR

SELECT count(*) from DM_CHG_LOG

SELECT count(*) from DM_CHG_LOG_AUDIT

SELECT count(*) from DM_CHG_LOG_EXCEPTION

SELECT count(*) from DM_CHG_LOG_SMRY

SELECT count(*) from DM_COMBINE_ERROR

SELECT count(*) from DM_MERGE_ACTION_LOG

SELECT count(*) from DM_MERGE_ACTION_LOG_DTL

SELECT count(*) from DM_MERGE_ERROR

SELECT count(*) from DM_PURGE_JOB_LOG

SELECT count(*) from DM_PURGE_JOB_LOG_TAB

SELECT count(*) from DM_SCHEMA_LOG

SELECT count(*) from DM_SCHEMA_OP_LOG

SELECT count(*) from DM2_DDL_OPS_LOG1

SELECT count(*) from EEM_IMPORT_ERROR

SELECT count(*) from EEM_LOG

SELECT count(*) from EEM_LOG_BLOB

SELECT count(*) from EEM_TRANS_DATA_ERROR

SELECT count(*) from EMPI_PROCESS_LOG

SELECT count(*) from EXPEDITE_LOG

SELECT count(*) from GL_TRANS_LOG

SELECT count(*) from HIM_TEMP_REQUEST_LOG

SELECT count(*) from MED_ADMIN_IDENT_ERROR

SELECT count(*) from MED_ADMIN_MED_ERROR

SELECT count(*) from MED_ADMIN_PT_ERROR

SELECT count(*) from MIC_ERR_DATA_R

SELECT count(*) from MIC_ERR_SCRIPT

SELECT count(*) from MIC_EVENT_LOG

SELECT count(*) from MIC_TASK_LOG

SELECT count(*) from MM_TRANS_ERROR_LOG

SELECT count(*) from MM_XF_ERROR_LOG

SELECT count(*) from MMC_ACTIVITY_LOG

SELECT count(*) from MM_APPROVAL_LOG

SELECT count(*) from MM_DB_LOG

SELECT count(*) from OEN_ERROR

SELECT count(*) from OEN_PRUNEJOB_LOG

SELECT count(*) from OEN_TELOG

SELECT count(*) from OEN_TXLOG

SELECT count(*) from OEN_TX_MAX_STATS_LOG

SELECT count(*) from OEN_TX_STATS_LOG

SELECT count(*) from ORM_ERROR_LOG

SELECT count(*) from PFT_CM_EVENT_LOG

SELECT count(*) from PFT_COMBINE_LOG

SELECT count(*) from PFT_EVENT_OCCUR_LOG

SELECT count(*) from PFT_GENERIC_LOG

SELECT count(*) from PHA_QUEUEERR

SELECT count(*) from PHA_QUEUELOG

SELECT count(*) from REORG_LOG

SELECT count(*) from REORG_LOG_PERM

SELECT count(*) from ROBOTICS_LOG_EVENTS

SELECT count(*) from ROLE_STATUS_OVRD_LOG

SELECT count(*) from SCH_LOG

SELECT count(*) from SCH_LOG_LIST

SELECT count(*) from SESSION_LOG

SELECT count(*) from STRT_MODEL_ASSAY_ERROR

Return to the earlier blog “What Is Measured Improves” to understand what to do with the data you gather.