Oracle RAC Cursor Usage Test
This test monitors the number of open cursors for every node of an Oracle cluster.
Target of the test : Oracle Server
Agent deploying the test : An internal agent
Outputs of the test : One set of results for every cluster node in the Oracle cluster monitored.
|
Measurement | Description | Measurement Unit | Interpretation |
---|---|---|---|
Current open cursors: |
The number of cursors currently opened by this node on the shared cluster database. |
Number |
Many open cursors can exist if any application does not properly close the ResultSets before closing a connection. Alternatively, many simultaneous queries to the database can also result in many open cursors. A continuous increase in open cursors is an indicator of a problem in an application’s use of the database. |
Percent open cursors: |
This metric reports the average percentage of open cursors with respect to the total allowed limit. |
Percent |
If the percentage of open cursors nears 100%, then this could invoke the “maximum open cursors exceeded” error message. If the percentage is consistently near 100%, consider increasing the value of the ‘open_cursors’ parameter in the init file. |