OEM View - RAC

The BMC Helix Continuous Optimization OEM View - RAC page is designed for presenting the capacity status of the Oracle Real Application clusters and its instances. There are two tabs Database RAC for Oracle oracle real application cluster entities and Rac instances for Rac instance entities.

Each tab has a overview table to show the status of the entities.

Database RAC

Database RAC tab shows the Oracle RAC entities. In the summary page, there's a RAC table.

The table below summarize the information that is provided by the tab, by selecting hidden columns, you can see all the provided columns:

Column Name	Description	Source Metrics or Calculation
RAC	Cluster name, this is the link to the detailed page of each cluster	Entname
DB Name	Database name	DB_NAME [LASTVAL]
DB Product Version	Database product version	DB_PRODUCT_VERSION [LASTVAL]
DB Total Allocated Size [GB]	The already allocated space for data, logs and control files	DB_TOTAL_ALLOCATED_SIZE [95th]
DB Total Used Size [GB]	The amount of used space within the allocated space	DB_TOTAL_USED_SIZE [95th]
DB CPU Used Pct [%]	Database cpu utilization	DB_CPU_USED [95th]
Instance Count	Number of the RAC instances
Days to Saturation	Number of days before the database utilization managed by the RAC will breach the thresholds

This is a screenshot of the summary table:

Database RAC - Detail page

By clicking each cluster name, the database RAC - detail page is shown:

In this detail page, there are two metrics trend chart

DB USED CPU (DB_CPU_USED)
DB TOTAL VS USED SIZE (DB_TOTAL_USED_SIZE, DB_TOTAL_ALLOCATED_SIZE)

There's a link "RAC Instance list" to RAC Instance summary pages which shows all database servers that are in the cluster.

This is a screenshot of the RAC Cluster Detail page:

RAC Instance Tab

RAC Instance tab shows the RAC instance entities. In the summary page, there's a Database RAC Instance table.

The table below summarize the information that is provided by the tab, by selecting hidden columns, you can see all the provided columns:

Column Name	Description	Source Metrics or Calculation
RAC Instance	RAC Instance name, this is the link to the detailed page of each instance	Entname
Rac	Cluster name, this is the link to the detailed page of each cluster	RAC Cluster
DB Host Name	Database host name	DB_HOST_NAME
DB Product Version	The database product version	DB_PRODUCT_VERSION
DB CPU Count	Number of cpu used by the database	DB_CPU_COUNT[LASTVAL]
DB Total Allocated Size [GB]	The already allocated space for data, logs and control files	DB_TOTAL_ALLOCATED_SIZE [95th]
DB Total Used Size [GB]	The amount of used space within the allocated space	DB_TOTAL_USED_SIZE [95th]
DB SGA Total Size [GB]	Total size for the SGA (System Global Area). Oracle specific metric.	DB_SGA_SIZE [95th]
DB PGA Size [GB]	Size for the PGA (Program Global Area). Oracle specific metric.	DB_PGA_SIZE [95th]
DB Logons	Total number of logons since the instance started. Useful only in V$SYSSTAT. It gives an instance overview of all processes that logged on.	DB_LOGONS [95th]
Db CPU Used Pct [%]	Database cpu utilization	DB_CPU_USED [95th]
DB Transactions Rate	The number of transaction per second	DB_TRANS_RATE [95th]
DB Physical Reads Rate [reads/s]	Number of physical reads per second	DB_PHYSICAL_READS_RATE [95th]
DB Physical Writes Rate [writes/s]	Number of physical write per second	DB_PHYSICAL_WRITES_RATE [95th]

This is a screenshot of the summary table:

Database RAC Instance - Detail page

By clicking each cluster name, the database RAC instance - detail page is shown: