Skip Headers
Oracle® Database Reference
11g Release 1 (11.1)

Part Number B28320-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF


V$SESSION_CURSOR_CACHE displays information on cursor usage for the current session.


The V$SESSION_CURSOR_CACHE view is not a measure of the effectiveness of the SESSION_CACHED_CURSORS initialization parameter.
Column Datatype Description
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 SESSION_CACHED_CURSORS.
COUNT NUMBER Current number of cursors (whether they are in use or not)
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