Oracle Session Resource Usage Test
In the database context, the connection between the user process and the server process is called a session. The server process communicates with the connected user process and performs tasks on behalf of the users.
This test tracks the resource usage of each session to the Oracle server and thus sheds light on the resource-intensive Oracle sessions. You can also use the detailed diagnostics provided by the test to understand why a user session is consuming CPU/memory resources excessively and then try to attack the problem source.
Note:
- This test will not report metrics for an Oracle 12c CDB server.
- This test does not apply to Windows platforms.
Target of the test : An Oracle 10g database server
Agent deploying the test : An internal agent
Outputs of the test : One set of results for the Oracle database server being monitored.
|
Measurement | Description | Measurement Unit | Interpretation |
---|---|---|---|
Maximum CPU used by a session: |
Indicates the percentage of CPU utilization that is the highest among all the sessions of this Oracle server. |
Percent |
A high value indicates that one/more Oracle sessions are consuming CPU excessively. Use the detailed diagnosis of the CPU used by Oracle sessions measure to know which session is consuming maximum CPU. Using this session information, you can optimize the query executed by that session to minimize CPU usage. |
CPU used by Oracle sessions: |
Indicates the percentage of CPU that is currently utilized by all sessions of this Oracle server. |
Percent |
|
Maximum memory used by a session: |
Indicates the percentage of memory utilization that is the highest among all the sessions of this Oracle server. |
Percent |
A high value indicates that one/more Oracle sessions are consuming memory excessively. Use the detailed diagnosis of the Memory used by Oracle sessions measure to view which session is consuming maximum memory. Using this session information, you can optimize the query executed by that session to reduce memory usage. |
Memory used by Oracle sessions: |
Indicates the percentage of memory that is currently utilized by all sessions of this Oracle server. |
Percent |