BUG-000094265 for ArcSDE/Enterprise Geodatabase

Bug ID Number	BUG-000094265
Submitted	February 18, 2016
Last Modified	April 2, 2025
Applies to	ArcSDE/Enterprise Geodatabase
Version found	10.1
Status	Will Not Be Addressed

Additional Information

The patch page has been updated with the information to update open_cursors. http://support.esri.com/download/2143 "The geodatabase on Oracle must be configured with open_cursors server_config parameter as described in Technical Article 000012229 after installing this patch on all ArcGIS versions." A new stored procedure is also included as part of a 10.5 geodatabase: http://desktop.arcgis.com/en/arcmap/latest/manage-data/gdbs-in-oracle/update-open-cursors.htm

Workaround

Set the geodatabase open_cursor parameter in the server_config table equal to that of the Oracle instance. For example if the Oracle instance had an open_cursor parameter of 4,000 us the following SQL to also set the geodatabase open_cursor to 4,000. SQL> insert into sde.server_config (prop_name,char_prop_value,num_prop_value) values ('OPEN_CURSORS',NULL,4000); SQL> commit;