Supported Metrics and Monitoring Configurations

Supported Metrics

Tabbed Interface with Table

Oracle RAC

Oracle Node

Oracle DB Instance

Oracle Disk Group

Oracle Disk

Metric Name	Display Name	Metric Category	Unit	Application Version	Description
oracle_cluster_NodeState	Oracle Cluster Node State	Availability		1.0.0	State of all nodes of the cluster such as Active or InActive. Possible values Active(0),INACTIVE(1)
oracle_cluster_online_NodeCount	Oracle Cluster Online Nodes Count	Availability	count	1.0.0	Count of nodes which are in Online state
oracle_cluster_InstanceCount	Oracle Cluster Instances Count	Availability	count	1.0.0	Count of Total Database Instances
oracle_cluster_active_InstanceCount	Oracle Cluster Active Instances Count	Availability	count	1.0.0	Count of Oracle Active Database Instance
oracle_cluster_check_db_Alive	Oracle Cluster Check DB Alive	Availability		1.0.0	Aliveness status of the Oracle Database Instance
oracle_cluster_ServicesStatus	Oracle Cluster Services Status	Availability		1.0.0	Status of the available Oracle RAC Cluster services. Possible values are ONLINE(0), OFFLINE(1), INTERMEDIATE(2), UNKNOWN(3)
oracle_cluster_sessions_Utilization	Oracle Cluster Sessions Utilization	Usage	%	1.0.0	To monitoring db sessions utilization
oracle_cluster_executions_PerTxn	Oracle Cluster Executions Per Transaction		Performance	1.0.0	The average amount of time per execution
oracle_cluster_executions_PerSec	Oracle Cluster Executions Per Sec	Performance		1.0.0	The average transactions per second
oracle_cluster_cpu_UsagePerSec	Oracle Cluster CPU Usage Per Sec	Usage		1.0.0	Represents the CPU usage per second by the database processes, measured in hundredths of a second.
oracle_cluster_cpu_UsagePerTxn	Oracle Cluster CPU Usage Per Transaction	Usage		1.0.0	The amount of CPU usage per transaction for the specific task or session.
oracle_cluster_database_cpu_time_Ratio	Oracle Cluster Database CPU Time Ratio	Usage		1.0.0	The Database CPU Time Ratio is of limited value as a tuning tool.The Database CPU Time Ratio is computed by dividing the amount of CPU used in the database by the amount of total database time. Total database time is the time spent by the database on user-level calls .
oracle_cluster_blocking_SessionCount	Oracle Cluster Blocking Session Count	Usage	count	1.0.0	To monitor the count of blocking sessions
oracle_cluster_session_limit_Usage	Oracle Cluster Session Limit Usage	Usage	%	1.0.0	To monitor the session limit usage
oracle_cluster_inactive_Sessions	Oracle Cluster Inactive Sessions	Availability	count	1.0.0	To monitors the inactive sessions.
oracle_cluster_active_Sessions	Oracle Cluster Active Sessions	Availability	count	1.0.0	To monitors the active sessions
oracle_cluster_system_waits_PerClass	Oracle Cluster System Waits PerClass	Performance	s	1.0.0	To monitor oracle system class waits (The system-level waits represent a high level summary of all session-level waits).This metric evaluated using this formula avg of waits = sum(time_waited)/sum(total_waits)
oracle_cluster_long_running_Queries	Oracle Cluster Long Running Queries	Performance	count	1.0.0	Validates the how many long running queries on particular database.
oracle_cluster_bufferCacheHitRatio_Pct	Oracle Cluster BufferCacheHitRatio Percentage	Usage	%	1.0.0	To monitoring Buffer cache hit ratio value in Percentage
oracle_cluster_sequence_Utilization	Oracle Cluster Sequence Utilization	Usage	%	1.0.0	To monitoring db sessions usage in Pct
oracle_cluster_temp_tableSpace_Utilization	Oracle Cluster Temp Tablespace Utilization	Usage	%	1.0.0	To monitor Temp tableSpace space usage in Pct
oracle_cluster_database_cdb_pdb_tableSpace_Utilization	Oracle Cluster Database CDB PDB Tablespace Utilization	Usage	%	1.0.0	To monitor the tableSpace utilization of the Oracle CDB & PDB.
oracle_cluster_database_cdb_pdb_tableSpace_SizeUsed	Oracle Cluster Database CDB and PDB Tablespace Size Used	Usage	MB	1.0.0	To monitor the tableSpace used size of the Oracle CDB and PDB
oracle_cluster_database_cdb_pdb_tableSpace_SizeFree	Oracle Cluster Database CDB and PDB Tablespace Size Free	Capacity	MB	1.0.0	To monitor the tableSpace free size of the Oracle CDB and PDB
oracle_cluster_process_Utilization	Oracle Cluster Processes Used pct	Usage	%	1.0.0	The percentage of elapsed time that the processor spends to execute a non-Idle thread(This doesn't includes CPU steal time)
oracle_cluster_dataguard_Status	Oracle Cluster Dataguard Status	Availability		1.0.0	To indicates the status of the Oracle Data Guard. Possible values are ALL(0) - Indicates all users other than SYS are prevented from making changes to any data in the database,STANDBY(1) - Indicates all users other than SYS are prevented from making changes to any database object being maintained by logical standby,NONE(2) - Indicates normal security for all data in the database.
oracle_cluster_dataguard_BrokerStatus	Oracle Cluster Dataguard Broker Status	Availability		1.0.0	To indicates the status of the Oracle Data Guard Broker. Possible value areENABLED(0) - Database is part of a broker configuration and broker management of the database is enabled,DISABLED(1) - Database is part of a broker configuration and broker management of the database is disabled. This value is displayed if the user disabled broker management of the database or configuration, or if broker management was disabled due to a role change (for example, the old primary was disabled after a failover operation).
oracle_cluster_dataguard_fs_FailoverMode	Oracle Cluster Dataguard Fast-Start Failover Mode	Availability		1.0.0	To indicates the status of the current fast-start failover mode. Possible values are: DISABLED(0) - Fast-start failover is disabled.OBSERVE-ONLY(1) - Fast-start failover is enabled in test drive mode.ZERO DATA LOSS(2) - Fast-start failover is enabled and a fast-start failover cannot incur any data loss.POTENTIAL DATA LOSS(3) - Fast-start failover is enabled and a fast-start failover can incur data loss within FastStartFailoverLagLimit seconds.

Metric Name	Display Name	Metric Category	Unit	Application Version	Description
oracle_node_Uptime	Oracle Node Uptime	Availability	m	1.0.0	Time lapsed since last reboot in minutes
oracle_node_cpu_Load	Oracle Node CPU Load	Usage		1.0.0	Monitors the system's last 1min, 5min and 15min load. It sends per cpu core load average.
oracle_node_cpu_Utilization	Oracle Node CPU Utilization	Usage	%	1.0.0	The percentage of elapsed time that the processor spends to execute a non-Idle thread(This doesn't includes CPU steal time)
oracle_node_memory_UsedSpace	Oracle Node Memory Used Space	Usage	GB	1.0.0	Physical and virtual memory usage in GB
oracle_node_memory_Utilization	Oracle Node Memory Utilization	Usage	%	1.0.0	Physical and virtual memory usage in GB
oracle_node_disk_usage_UsedSpace	Oracle Node Disk Usage UsedSpace	Usage	GB	1.0.0	Monitors disk used space in GB
oracle_node_disk_usage_Utilization	Oracle Node Disk Utilization	Usage	%	1.0.0	To monitor node disk utilization
oracle_node_disk_inode_Utilization	Oracle Node Disk Inode Utilization	Usage	%	1.0.0	This monitor is to collect DISK Inode metrics for all physical disks in a server.

Metric Name	Display Name	Metric Category	Unit	Application Version	Description
oracle_dbInstance_Status	Oracle DB Instance Status	Availability		1.0.0	Status of the Oracle Cluster Database Instance.Possible values are STARTED(0),MOUNTED(1),OPEN(2),OPEN MIGRATE(3)
oracle_dbInstance_Uptime	Oracle DB Instance Uptime	Availability	Days	1.0.0	Uptime (In Days) of the Oracle Cluster Database Instance

Metric Name	Display Name	Metric Category	Unit	Application Version	Description
oracle_diskGroup_State	Oracle ASM DiskGroup State	Availability		1.0.0	To monitor the states of the each ASM disk group.Possible values are CONNECTED(0),BROKEN(1),DISMOUNTED(2),MOUNTED(3),QUIESCING(4),RESTRICTED(5),UNKNOWN(6)
oracle_diskGroup_UsableFileMB	Oracle ASM Disk Group Usable File Size In MB	Usage	MB	1.0.0	To monitor the amount of free space that can be safely utilized.
oracle_diskGroup_RequiredMirrorFreeMB	Oracle ASM Disk Group Required Mirror Free Size In MB	Usage	MB	1.0.0	To monitor the amount of space that is required to be available in a given disk group in order to restore redundancy after one or more disk failures
oracle_diskGroup_Utilization	Oracle ASM DiskGroup Space Utilization	Usage	%	1.0.0	To monitor ASM DiskGroup Space Utilization

Metric Name	Display Name	Metric Category	Unit	Application Version	Description
oracle_disk_ModeStatus	Oracle ASM Disk Mode Status	Availability		1.0.0	To monitor ASM DATA diskgroup status..Possible values are ONLINE(0),OFFLINE(1),SYNCING(2)
oracle_disk_State	Oracle ASM Disk State	Availability		1.0.0	To monitor the state of the each ASM disk.Possible values are NORMAL(0),ADDING(1),DROPPING(2),HUNG(3),FORCING(4),UNKNOWN(5)
oracle_disk_Utilization	Oracle ASM Disk Utilization	Performance	%	1.0.0	To monitor the utilization of the each ASM Disk
oracle_disk_Reads	Oracle ASM Disk Reads	Usage	count	1.0.0	To monitor the Total number of I/O read requests for the disk
oracle_disk_Writes	Oracle ASM Disk Writes	Usage	count	1.0.0	To monitor the Total number of I/O write requests for the disk
oracle_disk_ReadErrors	Oracle ASM Disk Read Errors	Usage	count	1.0.0	To monitor the Total number of failed I/O read requests for the disk
oracle_disk_WriteErrors	Oracle ASM Disk Write Errors	Usage	count	1.0.0	To monitor the Total number of failed I/O write requests for the disk
oracle_disk_ReadTime	Oracle ASM Disk Read Time	Usage	s	1.0.0	To monitor the Total I/O time (in seconds) for read requests for the disk if the TIMED_STATISTICS initialization parameter is set to true (0 if set to false)
oracle_disk_WriteTime	Oracle ASM Disk Write Time	Usage	s	1.0.0	To monitor the Total I/O time (in seconds) for write requests for the disk if the TIMED_STATISTICS initialization parameter is set to true (0 if set to false)

Default Monitoring Configuration

Oracle RAC Multi Node Cluster application has default Global Device Management Policies, Global Templates, Global Monitors and Global Metrics in OpsRamp. You can customize these default monitoring configurations as per your business requirement by cloning respective Global Templates and Global Device Management Policies. It is recommended to clone them before installing the application to avoid noise alerts and data.

Default Global Device Management Policies
You can find the Device Management Policy for each Native Type at Setup > Resources > Device Management Policies. Search with suggested names in global scope:
{appName nativeType - version - Mode}
Ex: oracle-cluster Oracle RAC - 2 - RAC (i.e, appName = oracle-cluster, nativeType = Oracle RAC, version = 2, Mode = RAC)
Default Global Templates
You can find the Global Templates for each Native Type at Setup > Monitoring > Templates. Search with suggested names in global scope. Each template adheres to the following naming convention:
{appName Mode nativeType 'Template' - version}
Ex: oracle-cluster Standalone Oracle Node Template - 2 (i.e, appName = oracle-cluster, Mode = Standalone, nativeType = Oracle Node, version = 2)
Default Global Monitors
You can find the Global Monitors for each Native Type at Setup > Monitoring > Monitors. Search with suggested names in global scope. Each Monitors adheres to the following naming convention:
{monitorKey appName nativeType version}
Ex: Oracle Node Monitor oracle-cluster Oracle Node 2 (i.e, monitorKey = Oracle Node Monitor, appName = oracle-cluster, nativeType = Oracle Node, version = 2)