SELECT SID, n.NAME para_name, s.VALUE used
FROM SYS.v_$statname n, SYS.v_$sesstat s
WHERE n.NAME IN ('opened cursors current', 'session cursor cache count')
AND s.statistic# = n.statistic#;

查出sid后，如果sql还在运行，则可根据sid到v$session中去查sql_id，根据sql_id到v$sql去查语句。