Open Remote Cursors with Blocking

 
Snapshot Level
Application

 
Logical Data Grouping
appl

 
Monitor Switch
Basic

Resettable

No

Element Name
Element Type

open_rem_curs_blk
gauge

Description:  The number of remote blocking cursors currently open for this application.

Usage:  You can use this element in conjunction with "Open Remote Cursors" to calculate the percentage of remote 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:

• Check the pre-compile options for record blocking for treatment of ambiguous cursors

• Redefine cursors to allow for blocking (for example, if possible, specify FOR FETCH ONLY on your cursors).

"Rejected Block Cursor Requests" and "Accepted Block Cursor Requests" provide additional information that may help you tune your configuration parameters to improve row blocking in your application.

For the number of open blocking cursors used by applications connected to a local database see "Open Local Cursors with Blocking".