What's New?

New Monitoring Parameters are added to monitor Oracle Servers or Server Nodes. Several Parameters, such as Active Processes, Active Sessions, Active Users, Average Enqueue Timeouts, Average MTS Response Time, Average MTS Wait Time, Blocking Sessions, Buffer Cache Hit Ratio, Database File IO Reads, Database File IO Write Operations, Database FRA, Database User Expiry, Datafile Status, DB Block Corruption, DB File Recovery Status, Dictionary Cache Hit Ratio, Disk State, Disk group Size, and so on can be now monitored for the selected Oracle RAC Server/Server Nodes.

Configuration

On the SERVICE ENTITLEMENT page (Operations > Configuration > General > Service Entitlement), select the Tenant and Device Type as Server from the Filters pop-up.
Click ADD NEW from the ACTIONS panel.
Specify the Service Entitlement name.
Select the required parameter’s check box and click box and click SUBMIT.
Add an Oracle RAC Server/Server Node using Primary IP Address and Host Name on the ADD SERVER Specify the Oracle RAC Server/Server Node Name and user credentials to connect to a Server/ Server Node. For more information, see Adding Servers.
On the APPLICATION PARAMETER THRESHOLD page, configure the Threshold values for Monitoring Parameters of the selected Oracle RAC Server/Server Node. For more information, see Configuring Application Server Threshold.
On the CUSTOM SCHEDULER page, configure the job for monitoring the parameters of the selected Oracle RAC Server/Server Node. For more information, see Configuring Custom Scheduler.
Following is the job-wise parameter details:
- ORACLE_RAC_DISK
  1. Diskgroup Size
  2. Disk State
- ORACLE_RAC_DBDETAILS
  1. RMAN Backup
  2. DB Block Corruption
- ORACLE_RAC_LONGQUERIES
  1. Long Queries Count
  2. Long Queries ElapsedTime
- ORACLE_RAC_SYSTEMSTATISTICS
  1. Global Cache BlockLost
  2. Global Cache Average Block Receive Time
  3. Global Cache Block Access Latency
  4. Buffer Cache Hit Ratio
  5. Sort Ratio
- ORACLE_RAC_GLOBALCACHE
  1. Global Cache Corrupt Blocks
  2. MTS UGA Memory
  3. Global Cache Service Utilization
  4. Average Enqueue Timeouts
- ORACLE_RAC_RESOURCELIMIT
  1. Active Processes
  2. Active Sessions
- ORACLE_RAC_INSTANCE
  1. Average MTS Response Time
  2. Average MTS Wait Time
  3. UserLocks
  4. LockedUsers
  5. Redo Logs Contention
  6. Active Users
  7. NodesDown
- ORACLE_RAC_BLOCKINGSESSIONS
  1. Blocking Sessions
  2. Dictionary Cache Hit Ratio
- ORACLE_RAC_DBFILES
  1. Database File IO Reads
  2. Database File IO Write Operations
- ORACLE_RAC_TABLESPACE
  1. Tablespace Offline
  2. Tablespace Usage
  3. Database User Expiry
On the PERFORMANCE DASHBOARD page (Operations > User > Servers > Performance Dashboard), on the PERFORMANCE DASHBOARD page, select the Device Type as Server and Category as Oracle RAC.
Select the required parameters to view the threshold details on the display panel.

For more information about the list of newly added parameters in SummitAI Alps SP1 HF05, see SummitAI IT Operations Management Monitoring Parameters List (Alps SP1 HF05) and SummitAI IT Operations Management Online Help (Alps SP1).