Oracle RAC Unified Dashboard

The ORACLE RAC Unified Dashboard provides predefined list views for monitoring RAC Database Health, RAC Instance Node Performance, Access Latency, and Instance Node Health.
uim901
oracle_rac_UD
The ORACLE RAC Unified Dashboard provides predefined list views for monitoring RAC Database Health, RAC Instance Node Performance, Access Latency, and Instance Node Health.
Contents
Oracle RAC Required Data Sources
This table lists the QoS metrics, and subkeys or targets that must be activated to populate data in the ORACLE RAC dashboard.
QoS Metric
SubKey/Target
QOS_ORACLE_CHECK_DBALIVE
*
QOS_ORACLE_TABLESPACE_FREE
*
QOS_ORACLE_TABLESPACE_ALLOC_FREE
*
QOS_ORACLE_TABLESPACE_TEMP_FREE
*
QOS_ORACLE_FLASH_RECOVERY_AREA_MEMORY
*
QOS_ORACLE_TABLESPACE_SIZE
*
QOS_ORACLE_DATABASE_SIZE
*
QOS_ORACLE_INSTANCE_STATUS
*
QOS_ORACLE_RSRC_MGR_CPU_WAIT_TIME
*
QOS_ORACLE_MEMORY_USAGE
*
QOS_ORACLE_SGA_MEMORY_FREE
*
QOS_ORACLE_AVG_BUSY_TIME
*
QOS_ORACLE_ACTIVE_USER
*
QOS_ORACLE_ACTIVE_CONNECTION_RATIO
*
QOS_ORACLE_ACCESS_LATENCY
*
QOS_ORACLE_GC_CR_BLOCKS_SERVED
*
QOS_ORACLE_GC_CR_BLOCKS_RECEIVED
*
QOS_ORACLE_BUF_CACHEHIT_RATIO
*
QOS_ORACLE_DICT_CACHEHIT_RATIO
*
QOS_ORACLE_SESSION_WAITS
*
QOS_ORACLE_SYSTEM_STATICS
*
QOS_ORACLE_SYSTEM_WAITS
*
QOS_ORACLE_DBFILE_IO
*
An asterisk (*) means that the value for the first entry for the QoS is used. The asterisk should only be used when the QoS metric for a probe is known to return only one value.
Data Access Latency
This chart displays information about the Data Access Latency, which helps you understand how efficiently the cache is used for serving database queries. The optimum usage of cache is necessary for minimizing the query response time.
QoS Name
Description
Access Latency
Monitors the overall data access latency of the Oracle database.
Consistent Read Blocks Served
Monitors the total number of blocks constructed by the BSP process.
Consistent Read Blocks Received
Monitors the total number of blocks received.
Buffer Cache Hit Ratio
Monitors the buffer cache-hit ratio. Higher the ratio, better is the performance.
0 to 50.99 = Red
51 to 74.99 = Orange
75 to 84.99 = Yellow
85 to 100 = Green
Dictionary Cache Hit Ratio
Monitors the dictionary cache-hit ratio.
RAC Database Health
This chart displays information about the RAC Database Health, lets you monitor database status and disk space. The optimum disk space helps you effectively use your hardware resources while ensuring performance and availability.
Column Name
Description
Database Alive Status
Monitors connectivity to the database instance.
Total Free Tablespace
Monitors tablespaces for the available space.
Allocated Free Tablespace
Monitors tablespaces for available space left in allocated files.
Temporary Free Tablespace
Monitors temporary tablespaces for the available space.
Free Flash Recovery Memory
Monitors the available memory in the flash recovery area.
Tablespace Size
Monitors tablespaces size in MB.
Database Size
Monitors space size (in bytes) for each database, log and data files together.
RAC Instance Node Health
This chart displays information about the Instance Node Health, which helps you ensuring proper load balancing between all RAC instances. This chart alerts the Database Administrator (DBA) when any instance goes up or down.
QoS Name
Description
Sessions Wait Counter
Monitors the sessions wait counter.
System Statistical Counter
Monitors the various system statistical counters since start of the instance.
System Wait Counter
Monitors the system wait counter.
Database File IO
Monitors the database file I/O operations.
RAC Node Instance Performance
This chart displays information about the RAC Node Instance Performance, which symbolizes how efficiently all RAC instances are utilized for optimum database performance.
QoS Name
Description
Node Status
Monitors the state of the current instance.
Resource Manager CPU Wait Time
Monitors the total number of hundredths of a second that Oracle processes have been in a ready state.
Node Memory Usage
Monitors the memory consumption in bytes of Oracle users (PGA).
Free SGA Memory
Monitors the free SGA memory.
Average Busy Time
Monitors the number of hundredths of a second that a processor has been busy executing user or kernel code.
Currently Active Users
Checks the currently active Oracle users.
Active Connection Ratio
Monitors the active connection ratio.