13 January 2011

ORA-01000:maximum open cursors exceeded

 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>

No comments: