Default KPIs for Oracle database
This is a complete list of default KPIs for Oracle database monitoring.
|
KPI name |
Description | Unit |
Monitoring area |
Long description |
Collected on |
Collected for |
Server-specification |
Collector | Profile |
Recommended period |
|---|---|---|---|---|---|---|---|---|---|---|
| ORA_CPU_CORES | Oracle: CPU cores | Count | ORACLE | This KPI displays the total number of physical CPU cores on the Oracle database server. |
Remote system |
System |
Any server |
/DVD/MON_ORA_CL_COL_CPU_UTIL |
ORA_1DAY | 1 day |
|
ORA_CPU_IDLE |
Oracle: CPU idle |
% |
ORACLE |
This KPI displays the percentage of times in which the CPU had no task to perform or was waiting for an input/output. |
Remote system |
System |
Any server |
/DVD/MON_ORA_CL_COL_CPU_UTIL |
ORA_5MIN |
5 minutes |
|
ORA_CPU_NICE |
Oracle: CPU used by priority jobs |
% |
ORACLE |
This KPI displays the percentage of the CPU used that is by priority jobs on Oracle. |
Remote system |
System |
Any server |
/DVD/MON_ORA_CL_COL_CPU_UTIL |
ORA_5MIN |
5 minutes |
|
ORA_CPU_SYS |
Oracle: CPU used by system |
% |
ORACLE |
This KPI displays the percentage of the CPU that is used by the system on Oracle. |
Remote system |
System |
Any server |
/DVD/MON_ORA_CL_COL_CPU_UTIL |
ORA_5MIN |
5 minutes |
| ORA_CPU_THREADS | Oracle: CPU threads | Count | ORACLE | This KPI displays the total number of logical CPUs (threads) available on the Oracle database server. |
Remote system |
System |
Any server |
/DVD/MON_ORA_CL_COL_CPU_UTIL |
ORA_1DAY |
1 day |
|
ORA_CPU_USER |
Oracle: CPU used by user |
% |
ORACLE |
This KPI displays the percentage of the CPU that is used by users on Oracle. More details are available in transaction ST06. |
Remote system |
System |
Any server |
/DVD/MON_ORA_CL_COL_CPU_UTIL |
ORA_5MIN |
5 minutes |
|
ORA_CPU_WAIT |
Oracle: CPU I/O wait |
% |
ORACLE |
This KPI displays the CPU input/output wait time. I/O wait utilization accrues when the CPU would be able to perform some work, but all processes on the CPU are waiting for I/O responses. In SAP, you can view this KPI via transaction OS07; in Linux, with the uptime command. Values are collected for the database and for all application servers. However, this KPI only displays the minimum value – usually the I/O wait time of the database. The I/O wait on an application server is usually zero. |
Remote system |
System |
Any server |
/DVD/MON_ORA_CL_COL_CPU_UTIL |
ORA_5MIN |
5 minutes |
|
ORA_LOG_00060 |
ORA-00060: Deadlock detected while waiting for resource |
Count |
ORACLE |
This KPI displays the number of errors that have been identified in the alert logs with the ID ORA-00060: Deadlock detected while waiting for resource. |
Remote system |
System |
Any server |
/DVD/MON_ORA_CL_COL_ALERTLOG |
ORA_5MIN |
5 minutes |
|
ORA_LOG_01578 |
ORA-01578: Data block corrupted |
Count |
ORACLE |
This KPI displays the number of errors that have been identified in the alert logs with the ID ORA-01578: Data block corrupted. |
Remote system |
System |
Any server |
/DVD/MON_ORA_CL_COL_ALERTLOG |
ORA_5MIN |
5 minutes |
|
ORA_LOG_01653 |
ORA-01653: Unable to extend table &1 by &2 in tablespace &3 |
Count |
ORACLE |
This KPI displays the number of errors that have been identified in the alert logs with the ID ORA-01653: Unable to extend table &1 by &2 in tablespace &3. |
Remote system |
System |
Any server |
/DVD/MON_ORA_CL_COL_ALERTLOG |
ORA_5MIN |
5 minutes |
|
ORA_LOG_27072 |
ORA-27072: File I/O error |
Count |
ORACLE |
This KPI displays the number of errors that have been identified in the alert logs with the ID ORA-27072: File I/O error. |
Remote system |
System |
Any server |
/DVD/MON_ORA_CL_COL_ALERTLOG |
ORA_5MIN |
5 minutes |
|
ORA_LOG_30036 |
ORA-30036: Unable to extend segment by &1 in undo tablespace &2 |
Count |
ORACLE |
This KPI displays the number of errors that have been identified in the alert logs with the ID ORA-30036: Unable to extend segment by &1 in undo tablespace &2. |
Remote system |
System |
Any server |
/DVD/MON_ORA_CL_COL_ALERTLOG |
ORA_5MIN |
5 minutes |
|
ORA_MEM_BUFFER_CACHE |
Oracle: Buffer cache size |
MB |
ORACLE |
This KPI displays the buffer cache size on an Oracle database. |
Remote system |
Server |
Any server |
/DVD/MON_ORA_CL_COL_MEM |
ORA_5MIN |
5 minutes |
|
ORA_MEM_FREE |
Oracle: Free memory size |
MB |
ORACLE |
This KPI displays the free memory size on an Oracle database. |
Remote system |
Server |
Any server |
/DVD/MON_ORA_CL_COL_MEM |
ORA_5MIN |
5 minutes |
|
ORA_MEM_FREE_P |
Oracle: Free memory |
% |
ORACLE |
This KPI displays the free memory on an Oracle database as a percentage. |
Remote system |
Server |
Any server |
/DVD/MON_ORA_CL_COL_MEM |
ORA_5MIN |
5 minutes |
|
ORA_MEM_JAVA_POOL |
Oracle: Java pool size |
MB |
ORACLE |
This KPI displays the Java pool size on an Oracle database. |
Remote system |
Server |
Any server |
/DVD/MON_ORA_CL_COL_MEM |
ORA_5MIN |
5 minutes |
|
ORA_MEM_LARGE_POOL |
Oracle: Large pool size |
MB |
ORACLE |
This KPI displays the large pool size on an Oracle database. |
Remote system |
Server |
Any server |
/DVD/MON_ORA_CL_COL_MEM |
ORA_5MIN |
5 minutes |
|
ORA_MEM_SHARED_POOL |
Oracle: Shared pool size |
MB |
ORACLE |
This KPI displays the shared pool size on an Oracle database. |
Remote system |
Server |
Any server |
/DVD/MON_ORA_CL_COL_MEM |
ORA_5MIN |
5 minutes |
|
ORA_MEM_TOTAL |
Oracle: Total memory size |
MB |
ORACLE |
This KPI displays the total memory size on an Oracle database. |
Remote system |
Server |
Any server |
/DVD/MON_ORA_CL_COL_MEM |
ORA_5MIN |
5 minutes |
|
ORA_MEM_TOTAL_PGA_ALLOCATED |
Oracle: Total PGA allocated size |
MB |
ORACLE |
This KPI displays the total PGA allocated size on an Oracle database. |
Remote system |
Server |
Any server |
/DVD/MON_ORA_CL_COL_MEM |
ORA_5MIN |
5 minutes |
|
ORA_MEM_USED |
Oracle: Used memory size |
MB |
ORACLE |
This KPI displays the used memory size on an Oracle database. |
Remote system |
Server |
Any server |
/DVD/MON_ORA_CL_COL_MEM |
ORA_5MIN |
5 minutes |
|
ORA_MEM_USED_P |
Oracle: Used memory |
% |
ORACLE |
This KPI displays the used memory on an Oracle database as a percentage. |
Remote system |
Server |
Any server |
/DVD/MON_ORA_CL_COL_MEM |
ORA_5MIN |
5 minutes |
|
ORA_PGA_USED |
Oracle: Total PGA memory used size |
MB |
ORACLE |
This KPI displays the total size of the PGA memory used on an Oracle database. |
Remote system |
Server |
Any server |
/DVD/MON_ORA_CL_COL_MEM |
ORA_5MIN |
5 minutes |
|
ORA_SESS_ALL |
Number of all active and blocking Oracle sessions |
Count |
ORACLE |
This KPI displays the number of active and blocking Oracle user sessions for which background tasks (command value is not equal to 0) are excluded. Details are collected in the detail table ORACLE active sessions. |
Remote system |
System |
Any server |
/DVD/MON_ORA_CL_COL_SESSION |
ORA_5MIN |
5 minutes |
|
ORA_SESS_COMMIT |
Number of currently committing Oracle sessions |
Count |
ORACLE |
This KPI displays the number of Oracle sessions that are currently committing. This is an indicator of slowness in the area of database logging. In case of increased counters, check the wait states and I/O statistics for database logging. Details are collected in the detail table ORACLE active sessions. |
Remote system |
System |
Any server |
/DVD/MON_ORA_CL_COL_SESSION |
ORA_5MIN |
5 minutes |
|
ORA_SESS_ENQWAIT |
Number of Oracle sessions waiting for enqueue |
Count |
ORACLE |
This KPI displays the number of sessions that are waiting for an Oracle enqueue (typically lock waits). In case of a lock wait, you can identify the application causing the lock by checking the columns SID and BLOCKING_SESSION in the relevant detail table. Details are collected in the detail table ORACLE active sessions. |
Remote system |
System |
Any server |
/DVD/MON_ORA_CL_COL_SESSION |
ORA_5MIN |
5 minutes |
|
ORA_SESS_INST |
Number of active and blocking Oracle sessions per host |
Count |
ORACLE |
This KPI displays the number of active and blocking Oracle user sessions per host for which background tasks (command value is not equal to 0) are excluded. Details are collected in the detail table ORACLE active sessions. |
Remote system |
Server |
Only external server |
/DVD/MON_ORA_CL_COL_SESSION |
ORA_5MIN |
5 minutes |
