Oracle Unified Dashboard

The Oracle Unified Dashboard provides predefined list views for monitoring Available Tablespace, Database Utilization, Free SGA Memory, Resource Utilization Count, and Server Information.
uim901
oracle_UD
The Oracle Unified Dashboard provides predefined list views for monitoring Available Tablespace, Database Utilization, Free SGA Memory, Resource Utilization Count, and Server Information.
 If you enable any of these resources to collect metrics, you must disable alarm collection before you enable them (unless you want to collect the alarm data).
Contents
Oracle Required Data Sources
This table lists the probes, QoS metrics, and subkeys or targets that must be activated to populate data in the Oracle dashboard.
QoS
Subkey/Target
QOS_ORACLE_SGA_Memory_Free
*
QOS_ORACLE_check_dbalive
*
QOS_ORACLE_memory_usage
*
QOS_ORACLE_resource_utilization_count
*
QOS_ORACLE_buf_cachehit_ratio
*
QOS_ORACLE_database_size
*
QOS_ORACLE_tablespace_free
*
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.
Available Tablespace
This chart displays information about the Available Tablespace.
Column Name
Description
Available Tablespace
Measures the percentage of free space in a tablespace, considering the maximal possible tablespace size.
Database Utilization
This chart displays information about the database utilization.
Column Name
Description
Buffer Cache Hit Ratio
Percentage of pages found in the buffer cache without having to read from disk.
It can be low at the start of a new application, before the cache is filled with data. If it stays low for many intervals you should consider increasing the size of the cache (DB_BLOCK_BUFFERS).
Database Size
Monitors space size (in bytes) for each database, log, and data files together.
Free SGA Memory
This chart displays information about the free SGA memory.
Column Name
Description
Free SGA Memory
The SGA (System Global Area) is an area of memory (RAM) allocated when an Oracle Instance starts up.
It measures the SGA free memory usage in bytes.
Resource Utilization Count
This chart displays information about the resource utilization count.
Column Name
Description
Resource Utilization Count
Monitors database utilization for resources (Processes, Sessions and Transactions).
Server Information
This chart displays information about the server information.
Column Name
Description
Database Alive Status
Monitors connectivity to the database instance. This checkpoint tries to connect to an instance and the value returned as 1 or 0.
Memory Usage
Monitors memory consumption in bytes of Oracle users (PGA).
If the system has enough physical memory, increase parameter PGA_AGGREGATE_TARGET or change to automatic PGA management (9i). Otherwise look into V$PROCESS, V$PGASTAT, V$SQL_WORKAREA views to find most memory consuming Oracle user.