(DI-1911) Collector for monitoring alert logs from oracle DB
The collector for monitoring alert logs from oracle DB is named: /DVD/MON_ORA_CL_COL_ALERTLOG
It collects KPIs about alert logs from oracle DB. The KPIs are defined via KPI definition and input table /DVD/MON_ORALGI1.
Input table /DVD/MON_ORALGI1 sets extended KPI definition with 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 | Created at [automatically filled] |
In collector parameters needs to be defined:
Parameter name | Description |
MAX_PERIOD_IN_DAYS | Max period in days |
The collector provides also detailed output in detail table for relevant KPIs. The detail table is called: Oracle alert log details - /DVD/MON_ORA_S_ALERT_LOG_DE with following fields:
| Timestamp |
| System ID |
| Unique line number |
| Oracle alert text from log |
Some KPIs are provided in standard delivery with collector as examples:
KPI name | Description | Unit |
|---|---|---|
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 *.* by * in tablespace * | |
| ORA_LOG_27072 | ORA-27072 - File I/O error | |
| ORA_LOG_30036 | ORA-30036 - Unable to extend segm. by * in undo tab.sp. '*' |