Latest Contributions by George_Thompson

First, I would recommend looking at upgrading to a newer release. 10.5.x is in mature status and will be retired in Nov 2022 (https://support.esri.com/en/Products/Desktop/arcgis-desktop/arcmap/10-5-1#product-support) With that out of the way, here are some resources to help you understand / tune your Oracle geodatabase, if needed: https://community.esri.com/t5/implementing-arcgis-blog/what-is-egdbhealth/ba-p/886466 https://community.esri.com/t5/implementing-arcgis-blog/using-egdbhealth-to-evaluate-a-geodatabase/ba-p/886488 Here are my responses to your questions and will say that there may be other ways available: What Oracle parameters do I have to check to maximize performance (I want to start with the database first) ? I usually do not touch this unless needed Will removing Feature Dataset helps ? By how much performance will be gained in removing FD ? It depends, it could improve performance. I usually recommend FD's if you have advanced GDB functionality (topology, network datasets, etc.) or a requirement. Should I impose more on utilizing Subtype and Domain ? Are there anything else besides these...?  This is a great way to improve your data integrity and accuracy Does having many Map Services affect geodatabase performance ? Depends on the map services and complexity Which once degrades the server performance the least : Editing via ArcMap using Direct Connect or editing via FS, published at on-premise Portal, using ArcGIS Pro ? I would think that these are the same and is based on use case. One thing for sure is to suggest separation between Publication and Production geodatabase.               This is a good strategy if you are having issue already and have the need to separate the workloads.   Hope this helps in the initial conversation.  ... View more

Are you by chance connecting as a different version that what was registered before? ... View more

Kudos to all the winners of 2021, well deserved. We thank you for your contribution to the broader Esri and GIS communities! ... View more

Run the following SQL as the SDE user: SELECT file_spec FROM user_libraries WHERE library_name = 'ST_SHAPELIB';   If the path returned does NOT match your ST_SHAPELIB location, please update it: CREATE or REPLACE LIBRARY ST_SHAPELIB AS '<Location of ST_SHAPELIB file>';   Then: ALTER PACKAGE sde.st_geometry_shapelib_pkg COMPILE REUSE SETTINGS;   https://desktop.arcgis.com/en/arcmap/latest/manage-data/gdbs-in-oracle/configure-oracle-extproc.htm   This would work if you have already run the Create Enterprise Geodatabase or Create Spatial Type GP tools.   ... View more

Many people just use DB backup /  restore to "refresh" data in DEV from PROD. You should be able to use branch versioning to edit / "share" your UN data. ... View more

Yes, Branch and Traditional versioning can be used in the same enterprise geodatabase. The features classes can only participate in one or the other, NOT both. You would reconcile / post as normal, there would not be any conflict as they do not share feature classes that participate. As for the replication, you can edit the branch versioned data via the web as it is a service based architecture (Web GIS). Is there a reason that you would need to replicate with this model? Here are some great blogs to review: https://www.esri.com/arcgis-blog/products/arcgis-enterprise/data-management/to-branch-or-not-to-branch/ https://www.esri.com/arcgis-blog/products/arcgis-enterprise/data-management/branch-versioning-setting-the-stage/ https://www.esri.com/arcgis-blog/products/arcgis-pro/data-management/version-administrator-for-branch-versioned-data/ https://community.esri.com/t5/geodatabase-questions/blog-discussion-branch-versioning/td-p/835462 Let us know if you have any other questions. ... View more