VIEW: SYS.V_$SESSION_CURSOR_CACHE

Source

View Text - Preformatted

select "MAXIMUM","COUNT","OPENS","HITS","HIT_RATIO","CON_ID" from v$session_cursor_cache

View Text - HTML Formatted

SELECT "MAXIMUM"
, "COUNT"
, "OPENS"
, "HITS"
, "HIT_RATIO"
, "CON_ID"
FROM V$SESSION_CURSOR_CACHE