Does anyone knows if the open_cursor parameter in the init.ora relate to the max no. of open cursors for the entire db or each connection.
Printable View
Does anyone knows if the open_cursor parameter in the init.ora relate to the max no. of open cursors for the entire db or each connection.
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