oracle open_cursor监控

SELECT  max(a.value) as highest_open_cur, p.value as max_open_cur FROM v$sesstat a, v$statname b, v$parameter p WHERE  a.statistic# = b.statistic#  and b.name = 'opened cursors current' and p.name= 'open_cursors' group by p.value;

moseDoc ID 1477783.1

(Doc ID 2091529.1)How to Monitor and Tune the OPEN_CURSORS and SESSION_CACHED_CURSORS Parameters