Configuring the Open Cursors setting for a database instance

When you create a database instance, you must set the Open Cursors setting correctly for your database version.

• For the Oracle 11g database version, set Open Cursors to 500 using the following SQL command:

  ALTER SYSTEM SET open_cursors=500 SCOPE=BOTH;

Before you upgrade, ensure that the Open Cursors parameter is correctly set.

Copyright © 2007, 2016 Oracle and/or its affiliates. All rights reserved.