Open Local Cursors


 
Snapshot Level
Application

 
Logical Data Grouping
appl

 
Monitor Switch
Basic

Resettable

No

 

Element Name
Element Type

open_loc_curs
gauge

 

Description:  The number of local cursors currently open for this application, including those cursors counted by "Open Local Cursors with Blocking".

Usage:  You may use this element in conjunction with "Open Local Cursors with Blocking" to calculate the percentage of local cursors that are blocking cursors. If the percentage is low, you may be able to improve performance by improving the row blocking in the application.

For cursors used by remote applications, see "Open Remote Cursors".