What is the query to find the no. of current open cursors in an Oracle Instance?
Also, what is the accuracy/update frequency of this data?
I am using Oracle 10gR2
I'm not sure but it should be live data.
select name, value from v$parameter where upper(name) in ('OPEN_CURSORS') order by name;