VIEW: SYS.GV_$SESSION_CURSOR_CACHE

Source

View Text - Preformatted

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

View Text - HTML Formatted

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