Oracle Processes Test
For each Oracle instance, this test measures statistics pertaining to the smon, pmon, lgwr, dbw, reco, and ckpt processes.
Target of the test : An Oracle server
Agent deploying the test : An internal agent
Outputs of the test : One set of results for every SID monitored.
|
Measurement | Description | Measurement Unit | Interpretation |
---|---|---|---|
Processes running: |
Number of instances of a pmon, smon, lgwr, dbw, and reco processes currently executing. |
Number |
This value indicates if too many or too few processes corresponding to an application are executing on the host. |
CPU utilization: |
Total percentage CPU utilization of each process instance detected above. |
Percent |
A very high value could indicate that processes corresponding to the specified pattern are consuming excessive CPU resources. |
Memory utilization: |
The ratio of the resident set size of a process to the physical memory of the host system on which it executes, expressed as a percentage. |
Percent |
A sudden increase in memory utilization for a process may be indicative of memory leaks in the application. |