open_cursor in init.ora

[feng11]

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.

[ales]

http://download-west.oracle.com/docs...h1117.htm#6053

[RayaguruSD]

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