SQL to find the number of potential open cursors in Oracle: select value,name from v$parameter where name like ‘open_cursors’