PROCESSES
specifies the maximum number of operating system user processes that can simultaneously connect
to Oracle. Its value should allow for all background processes such as locks, job queue processes,
and parallel execution processes.
OPEN_CURSORS
specifies the maximum number of open cursors (handles to private SQL areas) a session can have at
once. You can use this parameter to prevent a session from opening an excessive number of cursors.
This parameter also constrains the size of the PL/SQL cursor cache which PL/SQL uses to avoid having
to reparse as statements are reexecuted by a user.
最初由 Toms_zhang 发布
[B]PROCESSES
specifies the maximum number of operating system user processes that can simultaneously connect
to Oracle. Its value should allow for all background processes such as locks, job queue processes,
and parallel execution processes.
OPEN_CURSORS
specifies the maximum number of open cursors (handles to private SQL areas) a session can have at
once. You can use this parameter to prevent a session from opening an excessive number of cursors.
This parameter also constrains the size of the PL/SQL cursor cache which PL/SQL uses to avoid having
to reparse as statements are reexecuted by a user. [/B]
谢谢你，请问"operating system user processes "具体指的是什么？如果在服务器上用sql*plus连接到oracle，应该算是一个，是吗?如果在客户端上用sql*plus连接到oracle,也应该算一个吗?
