Modify and query the maximum number of oracle cursors

Modify and query oracle Max cursors 1. View ORACLE Max cursors C: \ Documents and Settings \ Administrator> sqlplus "sys/orcl @ orcl as sysdba" SQL * Plus: release 9.2.0.1.0-Production on Thursday November 5 09:08:04 2009 Copyright (c) 1982,200 2, Oracle Corporation. all rights reserved. connect to: www.2cto.com Oracle9i Enterprise Edition Release 9.2.0.1.0-Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0-Production
SQL> show parameter open_cursors; name type value types ------------- ---------------------------- open_cursors integer 300 2. view the number of currently opened cursors SQL> select count (*) from v $ open_cursor; COUNT (*) www.2cto.com ---------- 17494 3. Modify the maximum number of ORACLE cursors SQL> alter system set open_cursors = 1000 scope = both; the system has changed.
SQL> show parameter open_cursors; NAME TYPE VALUE -------------------------------------- ------------------------------------ open_cursors integer 1000