Snapshot Information Level Application |
API Structure(s) sqlm_appl |
Monitor Group Basic |
Resettable |
No |
|
API Element Name Element Type |
open_rem_curs gauge |
Description: The number of remote cursors currently open for this application, including those cursors counted by "Open Remote Cursors with Blocking".
Usage: You may use this element in conjunction with "Open Remote Cursors with Blocking" 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. See "Open Remote Cursors with Blocking" for more information.
For the number of open cursors used by applications connected to a local database, see "Open Local Cursors".
[ Top of Page | Table of Contents | Glossary | Index ]