Collector for Oracle Memory Info

The technical name of the Collector for Oracle Memory Info is /DVD/MON_ORA_CL_COL_MEM.

This collector collects memory details of the Oracle database server. Some predefined KPIs with memory information are provided, but you can define and map additional KPIs via the collector input table.

Default KPIs Delivered with This Collector

The following default KPIs are delivered with this collector:

KPI name	Description	Unit	Detail table
ORA_MEM_BUFFER_CACHE	Oracle: Buffer cache size	MB	No
ORA_MEM_FREE	Oracle: Free memory size	MB	No
ORA_MEM_FREE_P	Oracle: Free memory	%	No
ORA_MEM_JAVA_POOL	Oracle: Java pool size	MB	No
ORA_MEM_LARGE_POOL	Oracle: Large pool size	MB	No
ORA_MEM_SHARED_POOL	Oracle: Shared pool size	MB	No
ORA_MEM_TOTAL	Oracle: Total memory size	MB	No
ORA_MEM_TOTAL_PGA_ALLOCATED	Oracle: Total PGA allocated size	MB	No
ORA_MEM_USED	Oracle: Used memory size	MB	No
ORA_MEM_USED_P	Oracle: Used memory	%	No
ORA_PGA_USED	Oracle: Total PGA memory used size	MB	No

Custom KPIs

The Collector for Oracle Memory Info enables you to create custom KPIs based on this collector. For more information about how to create a custom KPI, see the chapter Creating a KPI via Collectors with a Custom KPI.

Non-monitored memory metrics that can be mapped to custom KPI
Fixed SGA size
Redo buffers
Buffer cache size
Streams pool size
Shared IO pool size
Data transfer cache size
Granule size
Maximum SGA size
Startup overhead in shared pool
Free SGA memory available

After you create a KPI, you must map one of the above metrics to this KPI via the input table.

Input Table

The collector uses the input table /DVD/MON_ORAMMP.

The rules define which KPI is mapped to a certain Oracle memory metric. The collector comes with predefined table inputs that start with ORA* and are already being monitored.

Technical name	Column name	Description
KPI	KPI name	If you created the custom KPI to be mapped to a metric, enter its technical name here (Y* or Z*).
NAME	Statistics name	Name of the metric to be reported under the KPI name. You can choose a metric from the table above.
CREATED_BY	Created by user	Created by user [automatically filled]
CREATED_AT	Created at [TIMESTAMP]	Creation time [automatically filled]
CHANGED_BY	Last changed by user	Last changed by user [automatically filled]
CHANGED_AT	Last changed at [TIMESTAMP]	Last changed at [automatically filled]