Oracle: V$SQL

v$sql_cursor records information about each cursor that is currently active(?) in the current session (i.e. the session that is querying v$sql_cursor).

Join with V$SQLAREA

Join parent_handle with address of v$sql or v$sqlarea.

select
   cur.status,
   cur.child_pin,
   cur.pers_heap_mem,
   cur.work_heap_mem,
   cur.bind_vars,
   sql.sql_text
from
   v$sql_cursor cur                                         join
   v$sqlarea    sql on cur.parent_handle = sql.address
;

Github repository oracle-patterns, path: /Installed/dynamic-performance-views/sql/cursor/join-sqlarea.sql

Oracle: V$SQL_CURSOR

Join with V$SQLAREA

See also