4.8 RACNodeCPUUtil

Use this Knowledge Script to monitor CPU utilization of RAC Node. CPU utilization is measured in percentage.

This Knowledge Script is supported on Oracle 11gR2 and Oracle 12c.

4.8.1 Resource Object

Oracle RAC Node. When you drop a script on an Oracle RAC Node, a job executes on that node and monitors only that node.

4.8.2 Default Schedule

The default interval for this script is Every 15 minutes

4.8.3 Setting Parameter Values

Set the following parameters as needed:

Description

How to Set It

General Settings

Cluster(s) to exclude

Enter the cluster names to exclude with a comma (,) between each cluster name, to exclude the cluster from all jobs.

RAC Nodes(s) to exclude

Enter the RAC Node names to exclude with a comma (,) between each Rac Node name, to exclude the RAC Node Name from all jobs.

Event severity when job fails

Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 5 (red event indicator).

Event detail format

Select one of the following formats in which to view all events:

  • HTML Table

  • Plain Text

The default is HTML Table.

Enable debugging?

Select Yes to enable debugging. The default is unselected.

Raise event when AppManager fails to get metrics?

Select Yes to raise an event when AppManager fails to get the metrics. The default is Yes.

Event severity

Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 5 (red event indicator).

Event Settings

Raise event if CPU utilization in user space exceeds threshold?

Select Yes to raise an event when CPU utilization in user space exceeds the threshold. The default is unselected.

Threshold - Maximum CPU utilization in user space

Specify a maximum threshold for the percentage of CPU utilization in the user space. The default is 80%

Severity

Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 5 (red event indicator).

Raise event if CPU utilization in system space exceeds threshold?

Select Yes to raise an event if the CPU utilization in the system space exceeds the threshold. The default is unselected.

Threshold - Maximum CPU utilization in system space

Specify a maximum threshold for the percentage of CPU utilization in the system space. The default is 80%

Severity

Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 5 (red event indicator).

Raise event if CPU in idle state exceeds threshold?

Select Yes to raise an event if the CPU utilization in the idle state exceeds the threshold. The default is unselected.

Threshold - Maximum CPU in idle state

Specify a maximum threshold for the percentage of CPU utilization in idle state. The default is 90%

Severity

Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 5 (red event indicator).

Raise event if total CPU utilization exceeds threshold?

Select Yes to raise an event if the total CPU utilization in the system exceeds the threshold. The default is Yes.

Threshold - Maximum CPU utilization

Specify a maximum threshold for the percentage of CPU utilization in the system space. The default is 80%

Severity

Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 5 (red event indicator).

Data Collection

Collect data for…

Select Yes to collect data for charts and reports. When you enable data collection, and if monitoring of each metric is enabled, the Knowledge Script returns the following statistics for each CPU on which the script is running:

  • CPU utilization in user space percent?

  • CPU utilization in system space percent?

  • CPU in idle state in percent?

  • CPU utilization in percent?

The default for all the parameters except for Collect data for total CPU utilization in percent? is unselected.