23.3.02 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 | The already allocated space for data, logs and control files | DB_TOTAL_ALLOCATED_SIZE [95th] |
DB Total Used Size | The amount of used space within the allocated space | DB_TOTAL_USED_SIZE [95th] |
DB SGA Total Size | Total size for the SGA (System Global Area). Oracle specific metric. | DB_SGA_SIZE [95th] |
DB PGA Size | 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 | Number of physical reads per second | DB_PHYSICAL_READS_RATE [95th] |
DB Physical Writes Rate | 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:
In this detail page, there are two metrics trend chart
- DB Used CPU (DB_CPU_USED)
- DB logons vs Logons Current (DB_LOGONS, DB_LOGONS_CURRENT)
- DB Transaction Rate (DB_TRAN_RATE)
- DB Physical Read vs DB Physical Write (DB_PHYSICAL_READS_RATE, DB_PHYSICAL_WRITES_RATE)
- DB SGA/PAG Utilization (DB_PGA_SIZE, DB_SGA_SIZE)
This is a screenshot of the RAC Instance Detail page:
