Error :-
execute below command
[oracle@our12-dev ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 11.1.0.7.0 - Production on Thu Jan 13 18:11:32 2011
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> alter system set open_cursors = 10000;
System altered.
SQL> select * from v$parameter where name ='open_cursors';
NUM
----------
NAME
--------------------------------------------------------------------------------
TYPE
----------
VALUE
--------------------------------------------------------------------------------
DISPLAY_VALUE
--------------------------------------------------------------------------------
ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP ISBAS
--------- ----- --------- ----- ---------- ----- ----- -----
DESCRIPTION
--------------------------------------------------------------------------------
UPDATE_COMMENT
--------------------------------------------------------------------------------
HASH
----------
1365
NUM
----------
NAME
--------------------------------------------------------------------------------
TYPE
----------
VALUE
--------------------------------------------------------------------------------
DISPLAY_VALUE
--------------------------------------------------------------------------------
ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP ISBAS
--------- ----- --------- ----- ---------- ----- ----- -----
DESCRIPTION
--------------------------------------------------------------------------------
UPDATE_COMMENT
--------------------------------------------------------------------------------
HASH
----------
open_cursors
NUM
----------
NAME
--------------------------------------------------------------------------------
TYPE
----------
VALUE
--------------------------------------------------------------------------------
DISPLAY_VALUE
--------------------------------------------------------------------------------
ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP ISBAS
--------- ----- --------- ----- ---------- ----- ----- -----
DESCRIPTION
--------------------------------------------------------------------------------
UPDATE_COMMENT
--------------------------------------------------------------------------------
HASH
----------
3
NUM
----------
NAME
--------------------------------------------------------------------------------
TYPE
----------
VALUE
--------------------------------------------------------------------------------
DISPLAY_VALUE
--------------------------------------------------------------------------------
ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP ISBAS
--------- ----- --------- ----- ---------- ----- ----- -----
DESCRIPTION
--------------------------------------------------------------------------------
UPDATE_COMMENT
--------------------------------------------------------------------------------
HASH
----------
10000 NUM
----------
NAME
--------------------------------------------------------------------------------
TYPE
----------
VALUE
--------------------------------------------------------------------------------
DISPLAY_VALUE
--------------------------------------------------------------------------------
ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP ISBAS
--------- ----- --------- ----- ---------- ----- ----- -----
DESCRIPTION
--------------------------------------------------------------------------------
UPDATE_COMMENT
--------------------------------------------------------------------------------
HASH
----------
10000
NUM
----------
NAME
--------------------------------------------------------------------------------
TYPE
----------
VALUE
--------------------------------------------------------------------------------
DISPLAY_VALUE
--------------------------------------------------------------------------------
ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP ISBAS
--------- ----- --------- ----- ---------- ----- ----- -----
DESCRIPTION
--------------------------------------------------------------------------------
UPDATE_COMMENT
--------------------------------------------------------------------------------
HASH
----------
FALSE FALSE IMMEDIATE TRUE SYSTEM_MOD FALSE FALSE TRUE
NUM
----------
NAME
--------------------------------------------------------------------------------
TYPE
----------
VALUE
--------------------------------------------------------------------------------
DISPLAY_VALUE
--------------------------------------------------------------------------------
ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP ISBAS
--------- ----- --------- ----- ---------- ----- ----- -----
DESCRIPTION
--------------------------------------------------------------------------------
UPDATE_COMMENT
--------------------------------------------------------------------------------
HASH
----------
max # cursors per session
NUM
----------
NAME
--------------------------------------------------------------------------------
TYPE
----------
VALUE
--------------------------------------------------------------------------------
DISPLAY_VALUE
--------------------------------------------------------------------------------
ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP ISBAS
--------- ----- --------- ----- ---------- ----- ----- -----
DESCRIPTION
--------------------------------------------------------------------------------
UPDATE_COMMENT
--------------------------------------------------------------------------------
HASH
----------
NUM
----------
NAME
--------------------------------------------------------------------------------
TYPE
----------
VALUE
--------------------------------------------------------------------------------
DISPLAY_VALUE
--------------------------------------------------------------------------------
ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP ISBAS
--------- ----- --------- ----- ---------- ----- ----- -----
DESCRIPTION
--------------------------------------------------------------------------------
UPDATE_COMMENT
--------------------------------------------------------------------------------
HASH
----------
4033294835
NUM
----------
NAME
--------------------------------------------------------------------------------
TYPE
----------
VALUE
--------------------------------------------------------------------------------
DISPLAY_VALUE
--------------------------------------------------------------------------------
ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP ISBAS
--------- ----- --------- ----- ---------- ----- ----- -----
DESCRIPTION
--------------------------------------------------------------------------------
UPDATE_COMMENT
--------------------------------------------------------------------------------
HASH
----------
SQL>