Collector for Monitoring Alert Logs from Oracle DB

The technical name of the Collector for Monitoring Alert Logs from Oracle DB is /DVD/MON_ORA_CL_COL_ALERTLOG.

This collector collects KPIs about alert logs from the Oracle database. The KPIs are specified via the KPI definition and the input table /DVD/MON_ORALGI1.

The input table /DVD/MON_ORALGI1 sets the extended KPI definition. It contains the following fields:

KPI	KPI name
Rule number	KPI rule number
Alert pattern	Oracle alert log pattern
Changed by	Last changed by user [automatically filled]
Changed at	Last changed at [automatically filled]
Created by	Created by user [automatically filled]
Created at	Creation time [automatically filled]

Parameters

The following parameters are used for this collector:

Parameter name	Description
MAX_PERIOD_IN_DAYS	Max period in days

The collector also provides detailed information in the detail table for relevant KPIs. The detail table is called Oracle alert log details – /DVD/MON_ORA_S_ALERT_LOG_DE. It contains the following fields:

Timestamp

System ID

Unique line number

Oracle alert text from the log

Some KPIs are provided in the standard delivery with the collector as examples:

KPI name	Description
ORA_LOG_00060	ORA-00060: Deadlock detected while waiting for resource
ORA_LOG_01578	ORA-01578: Data block corrupted
ORA_LOG_01653	ORA-01653: Unable to extend table &1 by &2 in tablespace &3
ORA_LOG_27072	ORA-27072: File I/O error
ORA_LOG_30036	ORA-30036: Unable to extend segment by &1 in undo tablespace &2