Monitoring high CPU processes
Two parameters in the APP_PROCESS (OA_PROCESS) application enable you to monitor high CPU processes.
Parameter | Type | Description |
|---|---|---|
NumHighCPUProcess | Graph | Shows the number of Oracle processes with a CPU utilization that exceeds the High CPU Threshold.You can review the information specific to a point on the graph by double-clicking the annotated data point. |
ListHighCPUProcess | Report (text) | Shows the list of processes with a CPU utilization that exceeds the High CPU Threshold, including SQL text tracing. |
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*