SQL> select name from v$database;

NAME
---------
OGSF1

SQL> select count(*) from v$open_cursor;
COUNT(*)
----------
93

SQL> select a.value, b.name

from v$mystat a, v$statname b

where a.statistic# = b.statistic#

and b.name = 'opened cursors current';

VALUE NAME

---------- ----------------------------------------------------------------

1 opened cursors current