|
|
|
|
|
When you create a database instance, you must set the Cursor Sharing setting properly for your database version. For the Oracle database version 11.2.0.3 or later, set Cursor Sharing to FORCE.
The following SQL command changes the Cursor Sharing setting:
ALTER SYSTEM SET cursor_sharing=<Setting> SCOPE=BOTH;
In the previous command, Setting can be SIMILAR or FORCE, depending on the version of the Oracle database software in your environment.
Before you upgrade, ensure that the Cursor Sharing parameter is correctly set.
Copyright © 2007, 2016 Oracle and/or its affiliates. All rights reserved.