The number of times
that a request for an I/O block at server was
rejected and the request was converted to non-blocked I/O.
- Element identifier
- rej_curs_blk
- Element type
- counter
Table 1. Snapshot Monitoring InformationSnapshot Level |
Logical Data Grouping |
Monitor Switch |
Application |
appl |
Basic |
Table 2. Event Monitoring InformationEvent Type |
Logical Data Grouping |
Monitor Switch |
Connection |
event_conn |
- |
- Usage
- If there are many cursors blocking
data, the communication heap may
become full. When this heap is full, an error is not returned. Instead,
no
more I/O blocks are allocated for blocking cursors. If cursors are
unable
to block data, performance can be affected.
If a large number of cursors
were unable to perform data blocking, you may be able to improve performance
by:
- Increasing the size of the query_heap database
manager configuration
parameter.