[test:oracle]:/home/oracle> oerr ora 01000
01000, 00000, "maximum open cursors exceeded"
// *Cause:     A host language program attempted to open too many
//             cursors. The initialization parameter OPEN_CURSORS determined
//             the maximum number of cursors per user.
// *Action:    Modify the program to use fewer cursors. If this error
//             occurs often, shut down Oracle, increase the value of
//             OPEN_CURSORS, and then restart Oracle.


SQL> show parameter OPEN_CURSORS

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
open_cursors                         integer     300


SQL> alter system set open_cursors=3000 scope=both;

System altered.

SQL> show parameter OPEN_CURSORS

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
open_cursors                         integer     3000

版权声明：本文为博主原创文章，未经博主允许不得转载。

oracle