Oracle Cursor Usage Test
This test monitors the number of open cursors for a database instance. This test is disabled by default. To enable the test, go to the enable / disable tests page using the menu sequence : Agents -> Tests -> Enable/Disable, pick Oracle Database as the Component type, Performance as the Test type, choose this test from the disabled tests list, and click on the << button to move the test to the ENABLED TESTS list. Finally, click the Update button.
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 |
---|---|---|---|
Current open cursors: |
The number of cursors currently opened by applications using the 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. |