Configuring the Open Cursors setting for a database instance

When you create a database instance, you must set Open Cursors to 500 by running the following SQL command:

ALTER SYSTEM SET open_cursors=500 SCOPE=BOTH;

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