MAXIMUM |
NUMBER |
Maximum number of cursors to cache. Once you hit this number, some cursors will need to be closed in order to open more. The value in this column is derived from the initialization parameter OPEN_CURSORS . |
COUNT |
NUMBER |
The current number of cursors (whether they are in use or not) |
OPENED_ONCE |
NUMBER |
Number of cursors opened at least once |
OPEN |
NUMBER |
Current number of open cursors |
OPENS |
NUMBER |
Cumulative total of cursor opens minus one. This is because the cursor that is currently open and being used for this query is not counted in the OPENS statistic. |
HITS |
NUMBER |
Cumulative total of cursor open hits |
HIT_RATIO |
NUMBER |
Ratio of the number of times an open cursor was found divided by the number of times a cursor was sought |