Hello Everyone
After reading the following article...we use Oracle 19c...
Update open_cursors setting in geodatabases in Oracle—ArcGIS Pro | Documentation
The sde.gdb_util.update_open_cursors stored procedure updates the open_cursors parameter stored in the sde geodatabase repository
[Q1] In which SDE Repository Table is the open_cursors parameter stored?
Thanks.
Solved! Go to Solution.
That is correct, it updates the value in a safe and supported manner.
I know that many people just update the value via SQL, but always advise against it unless directed by Esri.
It can be done safely (update via SQL) but have seen MANY issues happen during the update process that impact other things.
There also are not many reasons to update the server_config table anymore.
I believe that it is in the sde.SERVER_CONFIG table in Oracle.
I do NOT recommend changing the value directly in the SDE repository tables.
Thank you George - so I assume the sde.gdb_util.update_open_cursors stored procedure updates the open_cursors parameter - no direct SQL.
That is correct, it updates the value in a safe and supported manner.
I know that many people just update the value via SQL, but always advise against it unless directed by Esri.
It can be done safely (update via SQL) but have seen MANY issues happen during the update process that impact other things.
There also are not many reasons to update the server_config table anymore.