V$SESSION_CURSOR_CACHE

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

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

Note:

1. The V$SESSION_CURSOR_CACHE view is not a measure of the effectiveness of the SESSION_CACHED_CURSORS initialization parameter.

2. To get view definition:

SELECT view_definition FROM v$fixed_view_definition

WHERE view_name='V$SESSION_CURSOR_CACHE';

3.

SELECT * FROM V$SESSION_CURSOR_CACHE;

MAXIMUM	COUNT	OPENED_ONCE	OPEN	OPENS	HITS	HIT_RATIO
50	4	4	0	43	43	1

Oracle data dictionary views

Oracle dynamic performance views