https://community.esri.com/t5/arcgis-utility-network-questions/mapping-and-charting-solutions-mcs-enterprise/m-p/1396165#M4402 <P><FONT size="5"><SPAN>Intended&nbsp;for database administrators as recommendations for establishing the product workspaces in an Enterprise Geodatabase (<SPAN>Oracle®, SQL Server®, PostgreSQL®</SPAN>).</SPAN></FONT></P><P><FONT size="5" color="#999999"><SPAN>_______________________________________________________________</SPAN></FONT></P><P><STRONG>Table of Contents</STRONG></P><P><SPAN><UL><LI style="list-style-type:disc; margin-left:25px; margin-bottom:1px;"><A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/mapping-and-charting-solutions-mcs-enterprise/ba-p/893351#toc-hId-1824760157" target="_blank">Esri MCS</A></LI><LI style="list-style-type:disc; margin-left:25px; margin-bottom:1px;"><A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/mapping-and-charting-solutions-mcs-enterprise/ba-p/893351#toc-hId--727396804" target="_blank">Esri MCS ArcGIS Extensions</A></LI><LI style="list-style-type:disc; margin-left:25px; margin-bottom:1px;"><A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/mapping-and-charting-solutions-mcs-enterprise/ba-p/893351#toc-hId-1015413531" target="_blank">Enterprise MCS Databases Best Practices</A></LI><LI style="list-style-type:disc; margin-left:50px; margin-bottom:1px;"><A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/mapping-and-charting-solutions-mcs-enterprise/ba-p/893351#toc-hId--1733256935" target="_blank">FAQ - Frequent Asked Questions</A></LI><LI style="list-style-type:disc; margin-left:50px; margin-bottom:1px;"><A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/mapping-and-charting-solutions-mcs-enterprise/ba-p/893351#toc-hId-9553400" target="_blank">Guide Books ArcGIS Pro</A></LI><LI style="list-style-type:disc; margin-left:50px; margin-bottom:1px;"><A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/mapping-and-charting-solutions-mcs-enterprise/ba-p/893351#toc-hId-1752363735" target="_blank">Guide Books ArcMap 10.8.x</A></LI><LI style="list-style-type:disc; margin-left:50px; margin-bottom:1px;"><A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/mapping-and-charting-solutions-mcs-enterprise/ba-p/893351#toc-hId--799793226" target="_blank">Guide Books Previous Releases</A></LI><LI style="list-style-type:disc; margin-left:25px; margin-bottom:1px;"><A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/mapping-and-charting-solutions-mcs-enterprise/ba-p/893351#toc-hId-1139530614" target="_blank">Enterprise MCS Databases Template Scripts</A></LI><LI style="list-style-type:disc; margin-left:50px; margin-bottom:1px;"><A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/mapping-and-charting-solutions-mcs-enterprise/ba-p/893351#toc-hId--1609139852" target="_blank">Geodatabases</A></LI><LI style="list-style-type:disc; margin-left:50px; margin-bottom:1px;"><A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/mapping-and-charting-solutions-mcs-enterprise/ba-p/893351#toc-hId-133670483" target="_blank">Database Template Scripts</A></LI><LI style="list-style-type:disc; margin-left:25px; margin-bottom:1px;"><A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/mapping-and-charting-solutions-mcs-enterprise/ba-p/893351#toc-hId--1336696408" target="_blank">Database Connections Best Practices</A></LI><LI style="list-style-type:disc; margin-left:25px; margin-bottom:1px;"><A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/mapping-and-charting-solutions-mcs-enterprise/ba-p/893351#toc-hId-406113927" target="_blank">Database Documentation Links</A></LI><LI style="list-style-type:disc; margin-left:25px; margin-bottom:1px;"><A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/mapping-and-charting-solutions-mcs-enterprise/ba-p/893351#toc-hId--2146043034" target="_blank">Database Storage Best Practices</A></LI><LI style="list-style-type:disc; margin-left:50px; margin-bottom:1px;"><A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/mapping-and-charting-solutions-mcs-enterprise/ba-p/893351#toc-hId-2094783238" target="_blank">Why to use Multiple Tablespaces and RAID 10</A></LI><LI style="list-style-type:disc; margin-left:50px; margin-bottom:1px;"><A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/mapping-and-charting-solutions-mcs-enterprise/ba-p/893351#toc-hId--457373723" target="_blank">BAARF - Battle Against Any RAID 5</A></LI><LI style="list-style-type:disc; margin-left:50px; margin-bottom:1px;"><A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/mapping-and-charting-solutions-mcs-enterprise/ba-p/893351#toc-hId-1285436612" target="_blank">Configuring Oracle Server for VLDB - Cary Millsap, Oracle</A></LI><LI style="list-style-type:disc; margin-left:50px; margin-bottom:1px;"><A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/mapping-and-charting-solutions-mcs-enterprise/ba-p/893351#toc-hId--1266720349" target="_blank">Optimal Storage Configuration Made Easy - Juan Loaiza, Oracle</A></LI></UL></SPAN></P><P><FONT size="3"><STRONG><SPAN class=""><SPAN><FONT color="#999999">________________________________________________________________________________________________</FONT></SPAN></SPAN></STRONG></FONT></P><P><STRONG><SPAN class=""><FONT size="4"><SPAN><A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/mapping-and-charting-solutions-mcs-enterprise/ba-p/893347" target="_blank">MCS Enterprise Databases Best Practices - Previous Releases</A></SPAN></FONT></SPAN></STRONG></P><P><FONT color="#999999">________________________________________________________________________________________________</FONT></P><H2 id="toc-hId-1824760157"><STRONG><SPAN class="">Esri MCS</SPAN></STRONG></H2><P><SPAN><A href="https://www.esri.com/en-us/industries/government/departments/national-mapping-charting" target="_blank" rel="nofollow noopener noreferrer">Esri's Mapping and Charting Solutions (MCS)</A>&nbsp;is used by all types of organizations to improve workflows and meet the most challenging mapping and charting production needs.</SPAN></P><P><STRONG>Key Reference Sites</STRONG> |&nbsp;Wiki -&nbsp;<A href="http://wiki.gis.com/wiki/index.php/System_Design_Strategies" target="_blank" rel="nofollow noopener noreferrer">System Design Strategies</A>&nbsp;| community.esri.com - <A href="https://community.esri.com/t5/implementing-arcgis/ct-p/implementing-arcgis" target="_blank">System Design Strategies</A></P><P><SPAN>An Esri ® Technical Reference February• 2026</SPAN></P><P><SPAN><FONT color="#999999">________________________________________________________________________________________________</FONT></SPAN></P><H2 id="toc-hId--727396804"><STRONG><SPAN class="">Esri MCS ArcGIS Extensions</SPAN></STRONG></H2><UL><LI><SPAN><A href="http://www.esri.com/arcgis/about-arcgis" target="_blank" rel="nofollow noopener noreferrer">About ArcGIS</A></SPAN></LI></UL><UL><LI><SPAN><A href="http://www.esri.com/software/arcgis/extensions/production-mapping" target="_blank" rel="nofollow noopener noreferrer">ArcGIS Production Mapping</A></SPAN></LI></UL><UL><LI><SPAN><A href="http://www.esri.com/software/arcgis/extensions/defense-mapping" target="_blank" rel="nofollow noopener noreferrer">ArcGIS Defense Mapping</A></SPAN></LI></UL><UL><LI><SPAN><A href="http://www.esri.com/software/arcgis/extensions/arcgis-data-reviewer" target="_blank" rel="nofollow noopener noreferrer">ArcGIS Data Reviewer</A></SPAN></LI></UL><UL><LI><SPAN><A href="http://www.esri.com/software/arcgis/extensions/arcgis-workflow-manager" target="_blank" rel="nofollow noopener noreferrer">ArcGIS Workflow Manager</A></SPAN></LI></UL><UL class="lia-list-style-type-disc"><LI><SPAN>Nautical:&nbsp; &nbsp;&nbsp;</SPAN><SPAN><A href="https://www.esri.com/en-us/arcgis/products/arcgis-maritime/overview" target="_blank" rel="nofollow noopener noreferrer">ArcGIS Maritime - Charting</A></SPAN>&nbsp; &nbsp; <SPAN><A href="https://www.esri.com/en-us/arcgis/products/arcgis-bathymetry/overview" target="_blank" rel="nofollow noopener noreferrer">ArcGIS Bathymetric</A></SPAN></LI></UL><UL class="lia-list-style-type-disc"><LI><SPAN>Aviation:&nbsp; &nbsp;&nbsp;</SPAN><SPAN><A href="https://www.esri.com/en-us/arcgis/products/arcgis-aviation-charting/overview" target="_blank" rel="nofollow noopener noreferrer">ArcGIS Aviation - Charting</A></SPAN>&nbsp; &nbsp; &nbsp;<SPAN><A href="https://www.esri.com/en-us/arcgis/products/arcgis-aviation-airports/overview" target="_blank" rel="nofollow noopener noreferrer">ArcGIS Aviation - Airports</A></SPAN></LI></UL><UL class="lia-list-style-type-disc"><LI><SPAN>Linear Referencing:&nbsp; &nbsp;&nbsp;</SPAN><SPAN><A href="https://www.esri.com/en-us/arcgis/products/arcgis-roads-highways/overview" target="_blank" rel="nofollow noopener noreferrer">Roads &amp; Highways</A>&nbsp; &nbsp; &nbsp; &nbsp;</SPAN><SPAN><A href="https://www.esri.com/en-us/arcgis/products/arcgis-pipeline-referencing/overview" target="_blank" rel="nofollow noopener noreferrer">Pipeline Referencing</A></SPAN></LI></UL><UL><LI><SPAN><A href="https://www.esri.com/en-us/arcgis/products/arcgis-indoors/overview" target="_blank" rel="nofollow noopener noreferrer">Indoors</A></SPAN></LI></UL><P><STRONG><SPAN class=""><FONT color="#999999">________________________________________________________________________________________________</FONT></SPAN></STRONG></P><H2 id="toc-hId-1015413531"><STRONG><SPAN class="">Enterprise MCS Databases Best Practices</SPAN></STRONG></H2><P><SPAN>The guide books are intended for database administrators as recommendations for establishing the product workspaces in an Enterprise Geodatabase (Oracle®, SQL Server®, PostgreSQL®).</SPAN></P><P><SPAN><EM>* a successful enterprise ArcGIS application deployment starts with a strong physical database design and best database administration practices</EM></SPAN></P><P><SPAN>Create a geodatabase for each software product workspace.</SPAN></P><PRE><SPAN>&nbsp;<STRONG>pm - production database</STRONG> <BR /> <EM>Production Mapping &amp; Defense Mapping - Topographic Mapping - MGCP, TDS, etc.</EM><BR /><EM> your gis data - create separate geodatabase for each <BR /> cartographic scale e.g. pm50 (1:50k); pm250 (1:250k)</EM></SPAN><BR /><SPAN>&nbsp;<STRONG>pl - product library workspace </STRONG><EM>- Product Library* (* ArcMap only)</EM></SPAN><BR /><SPAN>&nbsp;<STRONG>rev - data reviewer workspace </STRONG><EM>- Data Reviewer</EM></SPAN><BR /><SPAN>&nbsp;<STRONG>wmx - workflow manager workspace </STRONG><EM>- Workflow Manager</EM><STRONG><BR />&nbsp;mar1 - maritime charting database </STRONG><EM>- Nautical<BR /></EM> your gis data - create separate geodatabase for each <BR /> cartographic scale e.g. mar500k (1:500,000); mar1m (1:1,000,000)<STRONG><BR /> mar2 - bathymetric database </STRONG><EM>- Nautical</EM><STRONG><BR />&nbsp;aero1 - aeronautical charting database </STRONG><EM>- Aviation<BR /> your gis data - create separate geodatabase for each <BR /> cartographic scale e.g. aero500k (1:500,000); aero1m (1:1,000,000)<BR /><STRONG>&nbsp;aero2 - airports database </STRONG>- Aviation</EM><STRONG><BR />&nbsp;lr - linear referencing database </STRONG>- <EM>Roads &amp; Highways / Pipeline Referencing</EM><STRONG><BR />&nbsp;ind - indoors database </STRONG><EM>- Indoors</EM><STRONG><BR /></STRONG></SPAN></PRE><P><SPAN>For a very large featureclass create a separate dbtune keyword that points to separate tablespaces and datafiles in the database storage, this reduces disk contention and improves I/O.<BR /></SPAN></P><P><STRONG>UN - Utility Network</STRONG></P><PRE><FONT size="2"><SPAN>-</SPAN> Each Utility Network (UN) should be kept in its own separate geodatabase. </FONT><BR /><FONT size="2">- This keeps the database running smoothly by reducing contention and making <SPAN>performance better.<BR />- It also makes managing the database maintenance tasks easier, like rebuilding indexes and collecting <BR /> statistics.<BR />- We can easily clone that particular UN database, using database backups, when a copy is needed for <BR /> testing.<BR />- Also, it makes it easier to move the UN database to a different database server if necessary.<BR />- If something goes wrong and data is lost because of user mistakes, you can recover just that specific <BR /> UN database to a certain point in time. <BR />- This is especially useful if the lost data can’t be recovered through geodatabase versions.<BR />- This setup helps meet important goals for data recovery, called RPO (Recovery Point Objective) and <BR /> RTO (Recovery Time Objective), ensuring quick recovery and minimal data loss.<BR />- For example, imagine there are two separate UN geodatabases: one for gas, and one for water.<BR />- If someone deletes data from the water database in a geodatabase child version and then reconciles and <BR /> posts the edits to the geodatabase sde.default version, you can’t get that deleted data back from the <BR /> sde.default version anymore.<BR />- But, if you realize the mistake soon enough, the database administrator can restore the water database to <BR /> a previous point in time.<BR />- Doing this doesn’t affect the gas database edits at all.<BR />- If instead, all UNs were stored in one geodatabase, deleting or losing data from one UN could risk losing <BR /> edits from all datasets in that geodatabase.</SPAN></FONT></PRE><P>An Esri ® Technical Reference <SPAN>February• 2026</SPAN></P><P><STRONG><SPAN class=""><FONT color="#999999">________________________________________________________________________________________________</FONT></SPAN></STRONG></P><H3 id="toc-hId--1733256935"><STRONG><SPAN class="">FAQ - Frequent Asked Questions</SPAN></STRONG></H3><PRE><SPAN class=""><SPAN class="lia-unicode-emoji" title=":direct_hit:"><span class="lia-unicode-emoji" title=":direct_hit:">🎯</span></SPAN> <A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/how-load-large-featureclass-oracle-geodatabase/ba-p/1006704" target="_blank">How Load Large Featureclass Oracle Geodatabase</A></SPAN><BR /><SPAN class=""><SPAN class="lia-unicode-emoji" title=":direct_hit:"><span class="lia-unicode-emoji" title=":direct_hit:">🎯</span></SPAN> <A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/how-load-large-featureclass-sql-server-geodatabase/ba-p/1006710" target="_blank">How Load Large Featureclass SQL Server Geodatabase</A><BR /></SPAN><BR /><SPAN class=""><SPAN class="lia-unicode-emoji" title=":direct_hit:"><span class="lia-unicode-emoji" title=":direct_hit:">🎯</span></SPAN> <A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/how-to-move-and-upgrade-a-wmx-repository/ba-p/1043006" target="_blank">How to Move and Upgrade a WMX Repository Enterprise GDB</A></SPAN><BR /><SPAN class=""><SPAN class="lia-unicode-emoji" title=":direct_hit:"><span class="lia-unicode-emoji" title=":direct_hit:">🎯</span></SPAN> <A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/how-to-move-the-wmx-table-jtx-job-attachments/ba-p/1180748" target="_blank">How to Move the WMX table JTX_JOB_ATTACHMENTS</A><BR /></SPAN><BR /><SPAN class=""><SPAN class="lia-unicode-emoji" title=":direct_hit:"><span class="lia-unicode-emoji" title=":direct_hit:">🎯</span></SPAN> <A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/pro-branch-version-amp-oracle-table-compression/ba-p/1107155" target="_blank">Pro Branch Version &amp; Oracle Table Compression</A><BR /><SPAN class="lia-unicode-emoji" title=":direct_hit:"><span class="lia-unicode-emoji" title=":direct_hit:">🎯</span></SPAN> <A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/oracle-egdb-sde-repo-upgrade-using-oracle-restore/ba-p/1190454" target="_blank">Oracle eGDB SDE Repo Upgrade Using Oracle Restore Point</A> | <A href="https://esriis-my.sharepoint.com/:b:/g/personal/marc3932_esri_com/ERQI5OsB6W9NhDfIETaZN7sBlueMweVSJdT5NrFEVntFCA?e=6H92Li" target="_blank" rel="noopener nofollow noreferrer">Download PDF Version</A><BR /><SPAN class="lia-unicode-emoji" title=":direct_hit:"><span class="lia-unicode-emoji" title=":direct_hit:">🎯</span></SPAN> <A title="ArcSDE User-Schema Geodatabases in Oracle are deprecated" href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/arcsde-user-schema-geodatabases-in-oracle-are/ba-p/1502614" target="_blank">ArcSDE User-Schema Geodatabases in Oracle are deprecated</A><BR /><BR /><SPAN class="lia-unicode-emoji" title=":direct_hit:"><span class="lia-unicode-emoji" title=":direct_hit:">🎯</span></SPAN>&nbsp;<A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/how-to-move-the-oracle-enterprise-geodatabase-with/ba-p/1212116" target="_blank">How to Move the Oracle Enterprise Geodatabase with the Oracle Data Pump&nbsp;Utility</A><BR /><SPAN class="lia-unicode-emoji" title=":direct_hit:"><span class="lia-unicode-emoji" title=":direct_hit:">🎯</span></SPAN> <A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/how-to-move-a-postgresql-enterprise-geodatabase/ba-p/1231054" target="_blank">How to Move the PostgreSQL Enterprise Geodatabase with pg_dump and pg_restore</A><BR /><SPAN class="lia-unicode-emoji" title=":direct_hit:"><span class="lia-unicode-emoji" title=":direct_hit:">🎯</span></SPAN> <A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/how-to-move-a-sql-server-enterprise-geodatabase/ba-p/1233540" target="_blank">How to Move the SQL Server Enterprise Geodatabase with a database backup</A><BR /><BR /><SPAN class="lia-unicode-emoji" title=":direct_hit:"><span class="lia-unicode-emoji" title=":direct_hit:">🎯</span></SPAN>&nbsp;<A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/how-to-install-database-clients-for-arcgis/ba-p/1372426" target="_blank">How to Install Database Clients for ArcGIS</A><BR /><SPAN class="lia-unicode-emoji" title=":direct_hit:"><span class="lia-unicode-emoji" title=":direct_hit:">🎯</span></SPAN> <A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/how-to-install-the-oracle-database-client-for/ba-p/1236633" target="_blank">How to Install the Oracle Database Client for ArcGIS?</A><BR /><SPAN class="lia-unicode-emoji" title=":direct_hit:"><span class="lia-unicode-emoji" title=":direct_hit:">🎯</span></SPAN>&nbsp;<A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/how-to-install-the-sql-server-client-for-arcgis/ba-p/1238958" target="_blank">How to Install the SQL Server Client for ArcGIS?</A><BR /><BR /><SPAN class="lia-unicode-emoji" title=":direct_hit:"><span class="lia-unicode-emoji" title=":direct_hit:">🎯</span></SPAN>&nbsp;<A title="How to Upgrade the PostgreSQL and PostGIS version for the Enterprise Geodatabase on Windows" href="https://esriis-my.sharepoint.com/:b:/g/personal/marc3932_esri_com/EUF5y-AqHuNImi0cOzsYhSgBGzlLh3a2kbjB0IQpU2DTYA?e=6xjkkO" target="_blank" rel="noopener nofollow noreferrer">How to Upgrade the PostgreSQL and PostGIS version for the Ent. Geodatabase on Windows</A><BR /><SPAN class="lia-unicode-emoji" title=":direct_hit:"><span class="lia-unicode-emoji" title=":direct_hit:">🎯</span></SPAN> <A title="How to Upgrade the PostgreSQL and PostGIS version for the Enterprise Geodatabase on Linux" href="https://esriis-my.sharepoint.com/:b:/g/personal/marc3932_esri_com/EWYwGFllF59Hvayum2ejuWIBYRO-rRYq0ZPFQuWt1DIiYg?e=QBoPXW" target="_blank" rel="noopener nofollow noreferrer">How to Upgrade the PostgreSQL and PostGIS version for the Ent. Geodatabase on Linux</A><BR /><SPAN class="lia-unicode-emoji" title=":direct_hit:"><span class="lia-unicode-emoji" title=":direct_hit:">🎯</span></SPAN> <A title="How to Configure Windows Authentication for the PostgreSQL Enterprise Geodatabase" href="https://esriis-my.sharepoint.com/:b:/g/personal/marc3932_esri_com/EUd3_djdX5hBkBBkTRtQjhYBQk7d-ati3aoO6w8Bmg9IQg" target="_blank" rel="noopener nofollow noreferrer">How to Configure Windows Authentication for the PostgreSQL Enterprise Geodatabase</A><BR /></SPAN></PRE><PRE><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MarceloMarques_0-1748640648440.png" style="width: 400px;"><span class="lia-inline-image-display-wrapper" image-alt="MarceloMarques_0-1748640648440.png" style="width: 122px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/133553iF6A3884326C70068/image-size/medium?v=v2&amp;px=400" role="button" title="MarceloMarques_0-1748640648440.png" alt="MarceloMarques_0-1748640648440.png" /></span></SPAN><SPAN class=""><BR /><SPAN class="lia-unicode-emoji" title=":direct_hit:"><span class="lia-unicode-emoji" title=":direct_hit:">🎯</span></SPAN> </SPAN><A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/linux-docker-installation/ba-p/1619788" target="_blank">Linux Docker Installation - Esri Community</A><SPAN class=""><BR /><SPAN class="lia-unicode-emoji" title=":direct_hit:"><span class="lia-unicode-emoji" title=":direct_hit:">🎯</span></SPAN> </SPAN><A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/linux-docker-postgresql-arcsde-geodatabases/ba-p/1619457#" target="_blank">Linux Docker: Enterprise Geodatabase&nbsp;in&nbsp;PostgreSQL</A><SPAN class=""><BR /><SPAN class="lia-unicode-emoji" title=":direct_hit:"><span class="lia-unicode-emoji" title=":direct_hit:">🎯</span></SPAN> </SPAN><A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/linux-docker-sql-server-arcsde-geodatabases/ba-p/1619641" target="_blank">Linux Docker: Enterprise Geodatabase&nbsp;in&nbsp;SQL&nbsp;Server</A><BR /><SPAN class=""><SPAN class="lia-unicode-emoji" title=":direct_hit:"><span class="lia-unicode-emoji" title=":direct_hit:">🎯</span></SPAN></SPAN> <A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/linux-docker-oracle-arcsde-geodatabases/ba-p/1620527" target="_blank">Linux Docker: Enterprise Geodatabase&nbsp;in&nbsp;Oracle</A></PRE><P><STRONG><SPAN class=""><FONT color="#999999">________________________________________________________________________________________________</FONT></SPAN></STRONG></P><H3 id="toc-hId-9553400"><STRONG><SPAN class="">Guide Books ArcGIS Pro</SPAN></STRONG></H3><P><EM>The guide books are intended for database administrators to help establish the product workspaces in an Enterprise Geodatabase.</EM></P><PRE><SPAN><STRONG>ArcGIS Pro 3.x</STRONG></SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="lia-unicode-emoji" title=":globe_showing_americas:"><span class="lia-unicode-emoji" title=":globe_showing_americas:">🌎</span></SPAN> <STRONG>Topographic Mapping</STRONG></SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <A href="https://esriis-my.sharepoint.com/:b:/g/personal/marc3932_esri_com/EXn38W0fRslBqebXNP5xmrMB7wDZFA-gqaDPww8pCdGjQQ" target="_blank" rel="noopener nofollow noreferrer">Best Practices Production Mapping 3.x Workspace in Oracle®</A> October<EM>/21/2025</EM></SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <A href="https://esriis-my.sharepoint.com/:b:/g/personal/marc3932_esri_com/Ef5zZShfrE1CuWRQ5NSiOPoBH2qCcmJPF1E5tTA39BHO0Q" target="_blank" rel="noopener nofollow noreferrer">Best Practices Production Mapping 3.x Workspace in SQL Server®</A> October<EM>/21/2025</EM></SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <A href="https://esriis-my.sharepoint.com/:b:/g/personal/marc3932_esri_com/ERe-aBQ_AYVIlZmrGklhkzQBC7Ycep8xcp3mRgJhK_9aVg" target="_blank" rel="noopener nofollow noreferrer">Best Practices Production Mapping 3.x Workspace in PostgreSQL®</A> October<EM>/21/2025</EM></SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="lia-unicode-emoji" title=":magnifying_glass_tilted_left:"><span class="lia-unicode-emoji" title=":magnifying_glass_tilted_left:">🔍</span></SPAN> <STRONG>Data Reviewer (Classic) - Deprecated! Final Supported Version: ArcGIS Pro 3.6</STRONG></SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <A href="https://esriis-my.sharepoint.com/:b:/g/personal/marc3932_esri_com/EeKllYSx8JZBpYF95_b7GHsBoSh2AGmIq0e4CWVzcMfUhg" target="_blank" rel="noopener nofollow noreferrer">Best Practices Data Reviewer 3.x Workspace in Oracle®</A> October<EM>/21/2025</EM></SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <A href="https://esriis-my.sharepoint.com/:b:/g/personal/marc3932_esri_com/EfxFnLklEVBJo7_hkRx7Qv0B-EdWbzeYVlx58eHcpdvLBw" target="_blank" rel="noopener nofollow noreferrer">Best Practices Data Reviewer 3.x Workspace in SQL Server®</A> October<EM>/21/2025</EM></SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <A href="https://esriis-my.sharepoint.com/:b:/g/personal/marc3932_esri_com/EVBfz0pd6GpBjXuGWg8eAaYBNSESSnqK8b4txvU4sDA7cA" target="_blank" rel="noopener nofollow noreferrer">Best Practices Data Reviewer 3.x Workspace in PostgreSQL®</A> October<EM>/21/2025</EM></SPAN><BR /><BR /><FONT size="2"> <A href="https://support.esri.com/en-us/knowledge-base/deprecation-arcgis-data-reviewer-functionality-000038375#:~:text=Description,Recommendation" target="_blank" rel="noopener nofollow noreferrer">ArcGIS Data Reviewer Functionality</A><BR /> <A href="https://community.esri.com/t5/arcgis-pro-blog/deprecation-of-functionality-in-arcgis-data/ba-p/1658883" target="_blank">Deprecation of Functionality in ArcGIS Data Reviewer</A></FONT><BR /><FONT size="2"><EM> <STRONG>Final Supported Version:</STRONG> ArcGIS Pro 3.6 (released October 2025) </EM></FONT><FONT size="2"><EM>is the last version to support <BR /> legacy tools like Reviewer Batch Jobs, </EM></FONT><FONT size="2"><EM>Reviewer Sessions, and <BR /> the Reviewer Table.</EM></FONT><BR /><FONT size="2"><EM> <STRONG>Removal Version:</STRONG> Starting with ArcGIS Pro 3.7 (slated for April 2026), </EM></FONT><BR /><FONT size="2"><EM> these classic components will be completely removed and no longer available.</EM></FONT><BR /><FONT size="2"><EM> <STRONG>Reason for Change:</STRONG> This aligns with the final retirement of ArcMap 10.8.x in March 2026,</EM></FONT><BR /><FONT size="2"><EM> as the Classic workspace was primarily designed for interoperability with ArcMap.</EM></FONT><BR /><FONT size="2"><EM> <STRONG>Modern Alternative:</STRONG> Users must migrate to Attribute Rules-based workflows, </EM></FONT><BR /><FONT size="2"><EM> which utilize the Error Inspector for error management instead of the legacy </EM></FONT><BR /><FONT size="2"><EM> Reviewer Table.</EM> </FONT><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="lia-unicode-emoji" title=":memo:"><span class="lia-unicode-emoji" title=":memo:">📝</span></SPAN> <STRONG>Workflow Manager (Classic) - Deprecated! Final Supported Version: ArcGIS Pro 3.4</STRONG></SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <A href="https://esriis-my.sharepoint.com/:b:/g/personal/marc3932_esri_com/Ea_qxBJvrUFLoQT5cyI8VNkBe_PlTBplkkDNiCG7wj5mhA" target="_blank" rel="noopener nofollow noreferrer">Best Practices Workflow Manager 3.x Workspace in Oracle®</A> October<EM>/21/2025</EM></SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <A href="https://esriis-my.sharepoint.com/:b:/g/personal/marc3932_esri_com/EZ2AJlxe2-ZCiXoUGLlTYjcBHl_5UfZpfoqU3HtM7Jel9g" target="_blank" rel="noopener nofollow noreferrer">Best Practices Workflow Manager 3.x Workspace in SQL Server®</A> October<EM>/21/2025</EM></SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <A href="https://esriis-my.sharepoint.com/:b:/g/personal/marc3932_esri_com/EfP3u4jA6ytCiZMMzKYb0wIBinSlpAqt57z4PyfJZcWzAQ" target="_blank" rel="noopener nofollow noreferrer">Best Practices Workflow Manager 3.x Workspace in PostgreSQL®</A> October<EM>/21/2025<BR /><BR /> </EM><EM><A href="https://www.esri.com/arcgis-blog/products/workflow-manager/announcements/announcement-deprecation-of-arcgis-workflow-manager-classic" target="_blank" rel="noopener nofollow noreferrer">ArcGIS Pro 3.4 is the final release that supports Workflow Manager (Classic).</A><BR /><BR /></EM></SPAN><SPAN><STRONG> <SPAN class="lia-unicode-emoji" title=":globe_showing_europe_africa:"><span class="lia-unicode-emoji" title=":globe_showing_europe_africa:">🌍</span></SPAN> Aviation</STRONG> - Charting / Airports <BR /> <A href="https://esriis-my.sharepoint.com/:b:/g/personal/marc3932_esri_com/ES0veNolUg9OkM6z5JOvpBMBLOvs-Fl5SyZBH8yMZVrAeQ" target="_blank" rel="noopener nofollow noreferrer">Best Practices Aviation 3.x Workspace in Oracle®</A> October<EM>/21/2025</EM><EM><BR /> </EM><A href="https://esriis-my.sharepoint.com/:b:/g/personal/marc3932_esri_com/EXX9aY7e2oFNlpvudUJa8qkB5Ha2Fs1nTiKK9cPNHKrghA" target="_blank" rel="noopener nofollow noreferrer">Best Practices Aviation 3.x Workspace in SQL Server®</A> October<EM>/21/2025</EM><EM><BR /> </EM><A href="https://esriis-my.sharepoint.com/:b:/g/personal/marc3932_esri_com/Efn9LmvcSnZEvGHD_l__CzwBeoLI16Iu0LqQ3gqX8MffYg" target="_blank" rel="noopener nofollow noreferrer">Best Practices Aviation 3.x Workspace in PostgreSQL®</A> October<EM>/21/2025</EM><BR /><BR /><STRONG> <SPAN class="lia-unicode-emoji" title=":globe_with_meridians:"><span class="lia-unicode-emoji" title=":globe_with_meridians:">🌐</span></SPAN> Maritime</STRONG> - Charting<BR /> <A href="https://esriis-my.sharepoint.com/:b:/g/personal/marc3932_esri_com/EQq9uwbP6vhDvEcwaviI1scByq4v9-eulXsnEAhfqn-UjQ" target="_blank" rel="noopener nofollow noreferrer">Best Practices Maritime Charting 3.x Workspace in Oracle®</A> October<EM>/21/2025</EM><EM><BR /> </EM><A href="https://esriis-my.sharepoint.com/:b:/g/personal/marc3932_esri_com/EWpc-n4BkTxDiPJFTKQfvZoBJbKb9K6FKWH6EPagJkzYkA" target="_blank" rel="noopener nofollow noreferrer">Best Practices Maritime Charting 3.x Workspace in SQL Server®</A> October<EM>/21/2025</EM><EM><BR /> </EM><A href="https://esriis-my.sharepoint.com/:b:/g/personal/marc3932_esri_com/EfyRkpAdop9AkrJvkIlBJZEBXkOCyFcnTb57aLUw_MaIUQ" target="_blank" rel="noopener nofollow noreferrer">Best Practices Maritime Charting 3.x Workspace in PostgreSQL®</A> October<EM>/21/2025</EM><EM><BR /></EM><EM><BR /><STRONG> <SPAN class="lia-unicode-emoji" title=":globe_with_meridians:"><span class="lia-unicode-emoji" title=":globe_with_meridians:">🌐</span></SPAN> Maritime</STRONG> - Bathymetry<BR /></EM> <A href="https://esriis-my.sharepoint.com/:b:/g/personal/marc3932_esri_com/EdNCYa7zTD9GiOcpkef-D8MBcaA_xOgaacdGMPEes_48WQ" target="_blank" rel="noopener nofollow noreferrer">Best Practices Bathymetry 3.x Workspace in Oracle®</A> October<EM>/21/2025</EM><BR /> <A href="https://esriis-my.sharepoint.com/:b:/g/personal/marc3932_esri_com/EQ0MLK43PVpIhwyxxA1AzoYB52Sl1UzfAWVV-wQoCftjLw" target="_blank" rel="noopener nofollow noreferrer">Best Practices Bathymetry 3.x Workspace in SQL Server®</A> October<EM>/21</EM><EM>/2025</EM><BR /> <A href="https://esriis-my.sharepoint.com/:b:/g/personal/marc3932_esri_com/ER2AZkCX-XBPt6odlFhvUHABrxNRs7HQmjFfaQCtqjuwlg" target="_blank" rel="noopener nofollow noreferrer">Best Practices Bathymetry 3.x Workspace in PostgreSQL®</A> October<EM>/21</EM><EM>/2025</EM><EM><BR /><BR /></EM><STRONG> <SPAN class="lia-unicode-emoji" title=":globe_showing_asia_australia:"><span class="lia-unicode-emoji" title=":globe_showing_asia_australia:">🌏</span></SPAN> Linear Referencing </STRONG>- <EM>Roads &amp; Highways / Pipeline Referencing</EM><STRONG><BR /></STRONG> <A href="https://esriis-my.sharepoint.com/:b:/g/personal/marc3932_esri_com/EVcCsn2sb-VDk_g94HE5MYkBOUDL6CEg883VRl4nH2IywA" target="_blank" rel="noopener nofollow noreferrer">Best Practices LR 3.x Workspace in Oracle®</A> October<EM>/21/2025</EM><BR /> <A href="https://esriis-my.sharepoint.com/:b:/g/personal/marc3932_esri_com/Ec42RbSH1dlCiJM7FH85mzwB0OaBJfiA3BhU5263EUec_Q" target="_blank" rel="noopener nofollow noreferrer">Best Practices LR 3.x Workspace in SQL Server®</A> October<EM>/21/2025</EM><BR /> <A href="https://esriis-my.sharepoint.com/:b:/g/personal/marc3932_esri_com/Eb43Ifsz1I5EitAawi9dl_0BIVfhCZs5SfezS2u6XUPwiw" target="_blank" rel="noopener nofollow noreferrer">Best Practices LR 3.x Workspace in PostgreSQL®</A> October<EM>/21/2025</EM><EM><BR /><BR /></EM><STRONG> <SPAN class="lia-unicode-emoji" title=":globe_with_meridians:"><span class="lia-unicode-emoji" title=":globe_with_meridians:">🌐</span></SPAN> Indoors<BR /> </STRONG><A href="https://esriis-my.sharepoint.com/:b:/g/personal/marc3932_esri_com/EVRMNo6Rqm9PjBFJ_WwtBmcB7RFAXvbJlLRGwubeXxY1Zw" target="_blank" rel="noopener nofollow noreferrer">Best Practices Indoors 3.x Workspace in Oracle®</A> October<EM>/21/2025</EM><EM><BR /> </EM><A href="https://esriis-my.sharepoint.com/:b:/g/personal/marc3932_esri_com/EZopDcr_S35PmgRTJUjZMXIBFa4hiBnoklzmBQESdshFCA" target="_blank" rel="noopener nofollow noreferrer">Best Practices Indoors 3.x Workspace in SQL Server®</A> October<EM>/21/2025</EM><EM><BR /> </EM><A href="https://esriis-my.sharepoint.com/:b:/g/personal/marc3932_esri_com/EVYsSxngRRpFl_qC9o7LCs0B1mgaIOm8LTZ_3w2_E_Ivug" target="_blank" rel="noopener nofollow noreferrer">Best Practices Indoors 3.x Workspace in PostgreSQL®</A> October<EM>/21/2025</EM><EM><BR /></EM></SPAN></PRE><P><SPAN><STRONG><A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/mapping-and-charting-solutions-mcs-enterprise/ba-p/893347#toc-hId--1120423839" target="_blank">Previous Releases ArcGIS Pro</A></STRONG></SPAN></P><P><SPAN><STRONG><FONT color="#999999">________________________________________________________________________________________________</FONT></STRONG></SPAN></P><H3 id="toc-hId-1752363735"><SPAN><STRONG>Guide Books ArcMap 10.8.x</STRONG></SPAN></H3><P><SPAN><EM><BR /><A href="https://support.esri.com/en-us/products/arcmap/life-cycle" target="_blank" rel="noopener nofollow noreferrer">ArcMap Life Cycle</A> - <STRONG>Retirement March 01, 2026</STRONG><BR /><BR />The guide books are intended for database administrators to help establish the product workspaces in an Enterprise Geodatabase.</EM></SPAN></P><P><SPAN><EM><FONT size="2"><STRONG>Note:</STRONG> Roads and Highways, Pipeline Referencing, GeoEvent, Indoors, Aviation customers can follow the same best practices in the Production Mapping Guide Books</FONT></EM></SPAN></P><PRE><STRONG>ArcMap 10.8</STRONG> Feb 20<EM>, 2020<BR /><BR /></EM><SPAN><STRONG>&nbsp; <SPAN class="lia-unicode-emoji" title=":globe_showing_americas:"><span class="lia-unicode-emoji" title=":globe_showing_americas:">🌎</span></SPAN> Production Mapping</STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR /></SPAN><BR /><SPAN><STRONG>&nbsp;&nbsp;&nbsp; Production Database</STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <A href="https://desktop.arcgis.com/en/arcmap/latest/extensions/production-mapping-guide/admin-pm-oracle/introduction-to-storing-a-production-mapping-geodatabase-in-oracle.htm" target="_blank" rel="nofollow noopener noreferrer">Best Practices Production Mapping 10.8 Workspace in Oracle®</A>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <A href="https://desktop.arcgis.com/en/arcmap/latest/extensions/production-mapping-guide/admin-pm-sql-server/introduction-to-storing-the-production-mapping-workspace-in-sql-server.htm" target="_blank" rel="nofollow noopener noreferrer">Best Practices Production Mapping 10.8 Workspace in SQL Server®</A>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <A href="https://desktop.arcgis.com/en/arcmap/latest/extensions/production-mapping-guide/admin-pm-postgresql/introduction-to-storing-the-production-mapping-workspace-in-a-geodatabase-in-postgresql.htm" target="_blank" rel="nofollow noopener noreferrer">Best Practices Production Mapping 10.8 Workspace in PostgreSQL®</A>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR /></SPAN><BR /><SPAN><STRONG>&nbsp;&nbsp;&nbsp; <SPAN class="lia-unicode-emoji" title=":closed_book:"><span class="lia-unicode-emoji" title=":closed_book:">📕</span></SPAN> Product Library</STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <A href="https://desktop.arcgis.com/en/arcmap/latest/extensions/production-mapping-guide/admin-pl-oracle/introduction-to-configuring-the-product-library-in-oracle.htm" target="_blank" rel="nofollow noopener noreferrer">Best Practices Product Library 10.8 Workspace in Oracle®</A>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <A href="https://desktop.arcgis.com/en/arcmap/latest/extensions/production-mapping-guide/admin-pl-sql-server/introduction-to-configuring-the-product-library-in-sql-server.htm" target="_blank" rel="nofollow noopener noreferrer">Best Practices Product Library 10.8 Workspace in SQL Server®</A>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <A href="https://desktop.arcgis.com/en/arcmap/latest/extensions/production-mapping-guide/admin-pl-postgresql/introduction-to-storing-the-product-library-workspace-in-a-geodatabase-in-postgresql.htm" target="_blank" rel="nofollow noopener noreferrer">Best Practices Product Library 10.8 Workspace in PostgreSQL®</A>&nbsp;&nbsp;&nbsp; <BR /></SPAN><BR /><SPAN><STRONG>&nbsp; <SPAN class="lia-unicode-emoji" title=":magnifying_glass_tilted_left:"><span class="lia-unicode-emoji" title=":magnifying_glass_tilted_left:">🔍</span></SPAN> Data Reviewer</STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; <A href="https://desktop.arcgis.com/en/arcmap/latest/extensions/data-reviewer-guide/admin-dr-oracle/introduction-to-storing-the-reviewer-workspace-in-a-geodatabase-oracle.htm" target="_blank" rel="nofollow noopener noreferrer">Best Practices Data Reviewer 10.8 Workspace in Oracle®</A>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; <A href="https://desktop.arcgis.com/en/arcmap/latest/extensions/data-reviewer-guide/admin-dr-sql-server/introduction-to-storing-the-data-reviewer-workspace-in-an-enterprise-geodatabase-in-sql-server.htm" target="_blank" rel="nofollow noopener noreferrer">Best Practices Data Reviewer 10.8 Workspace in SQL Server®</A>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; <A href="https://desktop.arcgis.com/en/arcmap/latest/extensions/data-reviewer-guide/admin-dr-postgresql/introduction-to-storing-the-reviewer-workspace-in-a-geodatabase-in-postgresql.htm" target="_blank" rel="nofollow noopener noreferrer">Best Practices Data Reviewer 10.8 Workspace in PostgreSQL®</A>&nbsp;&nbsp;&nbsp; <BR /></SPAN><BR /><SPAN><STRONG>&nbsp; <SPAN class="lia-unicode-emoji" title=":memo:"><span class="lia-unicode-emoji" title=":memo:">📝</span></SPAN> Workflow Manager</STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; <A href="https://desktop.arcgis.com/en/arcmap/latest/extensions/workflow-manager/introduction-to-storing-the-workflow-manager-workspace-in-a-geodatabase-in-oracle.htm" target="_blank" rel="nofollow noopener noreferrer">Best Practices Workflow Manager 10.8 Workspace in Oracle®</A>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; <A href="https://desktop.arcgis.com/en/arcmap/latest/extensions/workflow-manager/introduction-to-storing-workflow-manager-workspace-in-sql-server.htm" target="_blank" rel="nofollow noopener noreferrer">Best Practices Workflow Manager 10.8 Workspace in SQL Server®</A>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; <A href="https://desktop.arcgis.com/en/arcmap/latest/extensions/workflow-manager/introduction-to-storing-the-workflow-manager-workspace-in-a-geodatabase-in-postgresql.htm" target="_blank" rel="nofollow noopener noreferrer">Best Practices Workflow Manager 10.8 Workspace in PostgreSQL®</A>&nbsp;&nbsp;&nbsp; <BR /></SPAN><BR /><SPAN><STRONG>&nbsp; <SPAN class="lia-unicode-emoji" title=":globe_with_meridians:"><span class="lia-unicode-emoji" title=":globe_with_meridians:">🌐</span></SPAN> Bathymetric Solution (BIS)</STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; <A href="https://desktop.arcgis.com/en/arcmap/latest/extensions/maritime-bathymetry-guide/oracle/introduction-to-configuring-the-bis-in-oracle.htm" target="_blank" rel="nofollow noopener noreferrer">Best Practices Bathymetry Solution (BIS) 10.8 Workspace in Oracle®</A>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; <A href="https://desktop.arcgis.com/en/arcmap/latest/extensions/maritime-bathymetry-guide/sql-server/introduction-to-storing-the-bis-workspace-in-sql-server.htm" target="_blank" rel="nofollow noopener noreferrer">Best Practices Bathymetry Solution (BIS) 10.8 Workspace in SQL Server®</A><BR /><BR /><STRONG>&nbsp; <SPAN class="lia-unicode-emoji" title=":globe_with_meridians:"><span class="lia-unicode-emoji" title=":globe_with_meridians:">🌐</span></SPAN> Nautical Solution (NIS)</STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp; <A href="https://desktop.arcgis.com/en/arcmap/latest/extensions/maritime-charting-guide/admin-nis-oracle/introduction-to-configuring-the-nis-in-oracle.htm" target="_blank" rel="nofollow noopener noreferrer">Best Practices Nautical Solution (NIS) 10.8 in Oracle®</A><BR />&nbsp;&nbsp;&nbsp; <A href="https://desktop.arcgis.com/en/arcmap/latest/extensions/maritime-charting-guide/admin-pl-oracle/introduction-to-configuring-the-nautical-product-library-in-oracle.htm" target="_blank" rel="nofollow noopener noreferrer">Best Practices Nautical Product Library 10.8 in Oracle®</A><BR />&nbsp;&nbsp;&nbsp; <A href="https://desktop.arcgis.com/en/arcmap/latest/extensions/maritime-charting-guide/admin-nis-sql-server/introduction-to-configuring-the-nis-in-sql-server.htm" target="_blank" rel="nofollow noopener noreferrer">Best Practices Nautical Solution (NIS) 10.8 in SQL Server®</A><BR />&nbsp;&nbsp;&nbsp; <A href="https://desktop.arcgis.com/en/arcmap/latest/extensions/maritime-charting-guide/admin-pl-sql-server/introduction-to-configuring-the-nautical-product-library-in-sql-server.htm" target="_blank" rel="nofollow noopener noreferrer">Best Practices Nautical Product Library 10.8 in SQL Server®</A></SPAN></PRE><P><STRONG><SPAN class=""><A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/mapping-and-charting-solutions-mcs-enterprise/ba-p/893347#toc-hId-622386496" target="_blank">Previous Releases ArcMap 10.7 / 10.6 / 10.5 / 10.4 / 10.3 / 10.2 / 10.1 / 10.0&nbsp;</A>.</SPAN></STRONG></P><P><FONT size="3"><STRONG><SPAN class=""><FONT color="#999999">________________________________________________________________________________________________</FONT></SPAN></STRONG></FONT></P><H3 id="toc-hId--799793226"><STRONG><FONT size="5"><SPAN class=""><A href="https://community.esri.com/groups/mapping-and-charting-enterprise-databases/blog/2019/08/28/enterprise-mapping-charting-solutions-mcs-databases-best-practices-previous-releases" target="_blank">Guide Books Previous Releases</A></SPAN></FONT></STRONG></H3><P><STRONG>Previous Releases</STRONG> -<SPAN>&nbsp;</SPAN><SPAN><A href="https://community.esri.com/groups/mapping-and-charting-enterprise-databases/blog/2019/08/28/enterprise-mapping-charting-solutions-mcs-databases-best-practices-previous-releases" target="_blank">ArcGIS Pro 2.x - ArcMap 10.7 / 10.6 / 10.5 / 10.4 / 10.3 / 10.2 / 10.1 / 10.0&nbsp;</A>.</SPAN></P><P><STRONG><SPAN class=""><FONT color="#999999">________________________________________________________________________________________________</FONT></SPAN></STRONG></P><H2 id="toc-hId-1139530614"><STRONG><SPAN class="">Enterprise MCS Databases Template Scripts</SPAN></STRONG></H2><P>How to install, configure, backup and maintain<SPAN>&nbsp;</SPAN><STRONG>Very Large MCS Enterprise Databases (VLMCSEDB)</STRONG>, detailed instructions for data loading, backup and recovery and to manage multiple user logins.</P><P><EM>*For Professional Database Administrators, requires advanced RDBMS and advanced Geodatabase experience.</EM></P><P><SPAN>An Esri ® Technical Reference February• 2026</SPAN></P><H3 id="toc-hId--1609139852"><SPAN><STRONG>Geodatabases</STRONG></SPAN></H3><P><SPAN>Create a geodatabase for each software product workspace.</SPAN></P><PRE><SPAN>&nbsp;<STRONG>pm - production database</STRONG> <BR /> <EM>Production Mapping &amp; Defense Mapping - Topographic Mapping - MGCP, TDS, etc.</EM><BR /><EM> your gis data - create separate geodatabase for each <BR /> cartographic scale e.g. pm50 (1:50k); pm250 (1:250k)</EM></SPAN><BR /><SPAN>&nbsp;<STRONG>pl - product library workspace </STRONG><EM>- Product Library* (* ArcMap only)</EM></SPAN><BR /><SPAN>&nbsp;<STRONG>rev - data reviewer workspace </STRONG><EM>- Data Reviewer</EM></SPAN><BR /><SPAN>&nbsp;<STRONG>wmx - workflow manager workspace </STRONG><EM>- Workflow Manager</EM><STRONG><BR />&nbsp;mar1 - maritime charting database </STRONG><EM>- Nautical</EM><STRONG><BR /> mar2 - bathymetric database </STRONG><EM>- Nautical</EM><STRONG><BR />&nbsp;aero1 - aeronautical charting database </STRONG><EM>- Aviation<BR /><STRONG>&nbsp;aero2 - airports database </STRONG>- Aviation</EM><STRONG><BR />&nbsp;lr - linear referencing database </STRONG>- <EM>Roads &amp; Highways / Pipeline Referencing</EM><STRONG><BR />&nbsp;ind - indoors database </STRONG><EM>- Indoors</EM></SPAN></PRE><P><SPAN>For a very large featureclass create a separate dbtune keyword that points to separate tablespaces and datafiles in the database storage, this reduces disk contention and improves I/O.<BR /><BR /></SPAN></P><P><STRONG>UN - Utility Network</STRONG></P><PRE><FONT size="2"><SPAN>-</SPAN> Each Utility Network (UN) should be kept in its own separate geodatabase. </FONT><BR /><FONT size="2">- This keeps the database running smoothly by reducing contention and making <SPAN>performance better.<BR />- It also makes managing the database maintenance tasks easier, like rebuilding indexes and collecting <BR /> statistics.<BR />- We can easily clone that particular UN database, using database backups, when a copy is needed for <BR /> testing.<BR />- Also, it makes it easier to move the UN database to a different database server if necessary.<BR />- If something goes wrong and data is lost because of user mistakes, you can recover just that specific <BR /> UN database to a certain point in time. <BR />- This is especially useful if the lost data can’t be recovered through geodatabase versions.<BR />- This setup helps meet important goals for data recovery, called RPO (Recovery Point Objective) and <BR /> RTO (Recovery Time Objective), ensuring quick recovery and minimal data loss.<BR />- For example, imagine there are two separate UN geodatabases: one for gas, and one for water.<BR />- If someone deletes data from the water database in a geodatabase child version and then reconciles and <BR /> posts the edits to the geodatabase sde.default version, you can’t get that deleted data back from the <BR /> sde.default version anymore.<BR />- But, if you realize the mistake soon enough, the database administrator can restore the water database to <BR /> a previous point in time.<BR />- Doing this doesn’t affect the gas database edits at all.<BR />- If instead, all UNs were stored in one geodatabase, deleting or losing data from one UN could risk losing <BR /> edits from all datasets in that geodatabase.</SPAN></FONT></PRE><P>An Esri ® Technical Reference October• 2025</P><H3 id="toc-hId-133670483"><SPAN><STRONG>Database Template Scripts</STRONG></SPAN></H3><P><SPAN>&nbsp;- the scripts cover the guide books best practices</SPAN></P><P><SPAN>&nbsp;- the scripts also have very advanced rdbms and advanced geodatabase best practices for <STRONG>VLMCSEDB</STRONG> that go beyond the guide books recommendations</SPAN></P><PRE><STRONG><FONT size="4">Oracle&nbsp;</FONT><BR /> </STRONG><SPAN><STRONG>Oracle 21c / 19c / 18c / 12c (12.2, 12.1) </STRONG></SPAN><BR /><SPAN>&nbsp;<SPAN>&nbsp;&nbsp; - For consolidation going forward adopt the Oracle 12c multi-tenant architecture:</SPAN></SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1 CDB (container database): <BR /> "mcs" hosts PDB's (pluggable databases): <BR /> "pm", "pl", "rev", "wmx", "mar", "aero", "lr", "ind"</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; each pluggable database is a standalone geodatabase with only <BR /> the sde master repository installed</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; - Discontinue the use of Esri user-schema geodatabases <BR /> (1 oracle database - multiple geodatabases)<BR /></SPAN> <A href="https://esriis-my.sharepoint.com/:u:/g/personal/marc3932_esri_com/ERvVkkyuoVFKv-PEPigg6CIB0iGjmIM2d_UNUvhRQU47Yg" target="_blank" rel="noopener nofollow noreferrer">ArcGIS Pro 3.x &amp; ArcMap 10.9.x</A> <STRONG>Oct 22, 2025</STRONG> <SPAN><STRONG>*New</STRONG></SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; <SPAN><A href="https://esriis-my.sharepoint.com/:u:/g/personal/marc3932_esri_com/EeizWf86Y0ZFjV-pzmIpeW0BIFQiBMz4tS3qsXNFwZ8yPQ?e=FZsNZO" target="_blank" rel="noopener nofollow noreferrer">ArcGIS Pro 2.3 / 2.4 &amp; ArcMap 10.7 / 10.8</A>&nbsp;Dec</SPAN><EM>&nbsp;18, 2020</EM></SPAN><BR /><SPAN>&nbsp;&nbsp; &nbsp;<A href="https://esriis-my.sharepoint.com/:u:/g/personal/marc3932_esri_com/EZAaR-pbz1FClJ11JVcpdQEBNZjkQs7n0A5l40E1YM_dDQ?e=RakIwA" target="_blank" rel="noopener nofollow noreferrer"><SPAN>ArcGIS Pro 2.2 &amp; ArcMap 10.6 / 10.5 / 10.4 / 10.3 / 10.2</SPAN></A> <EM>Aug 02, 2018</EM></SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; <A href="https://esriis-my.sharepoint.com/:u:/g/personal/marc3932_esri_com/EaH080zGNwxPrawxfSQRIAwB58sGgS961qqzp06TuNDFVw?e=9bUHXq" target="_blank" rel="noopener nofollow noreferrer"><SPAN>MCS Oracle 12c: Step-by-step Installation of Oracle RAC 12c on VMWare</SPAN></A> <EM>Nov 12, 2017</EM></SPAN><BR /><SPAN><EM>&nbsp; &nbsp; <A href="https://esriis-my.sharepoint.com/:b:/g/personal/marc3932_esri_com/Efi9cGkkzbROk_xU4IGgfqIB2PzfcBwheWYK87rVb0PTfQ?e=TZoP9M" target="_blank" rel="noopener nofollow noreferrer">How to Load a Large Featureclass in an Oracle Geodatabase</A></EM>&nbsp; &nbsp;Oct 23, 2020<BR /></SPAN><SPAN><EM>&nbsp; &nbsp; <A href="https://esriis-my.sharepoint.com/:b:/g/personal/marc3932_esri_com/ERQI5OsB6W9NhDfIETaZN7sBlueMweVSJdT5NrFEVntFCA?e=6H92Li" target="_blank" rel="noopener nofollow noreferrer">Oracle Geodatabase SDE Repository Upgrade using Oracle Restore Point</A></EM>&nbsp; &nbsp;Sep 06, 2022<BR /></SPAN> <EM><SPAN class=""><A href="https://esriis-my.sharepoint.com/:b:/g/personal/marc3932_esri_com/EUxvvSScXb5OplzNPP4Axq0BKrRTcKgd7Jrcr8KKWWCqHg?e=XsgKVI" target="_blank" rel="noopener nofollow noreferrer">How to Move eGDB using Oracle Data Pump</A></SPAN></EM> Sep 13, 2022<BR /><SPAN>&nbsp;<STRONG>Oracle 11gR2</STRONG></SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp; <A href="https://esriis-my.sharepoint.com/:u:/g/personal/marc3932_esri_com/EVk0oJf73JFMqu-1gcYdnoIBny1I-8lj42co_wurGMrNXQ?e=k6Y5Dg" target="_blank" rel="noopener nofollow noreferrer"><SPAN>ArcMap 10.2 / 10.1</SPAN></A> <EM>March 27, 2014</EM></SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp; - For consolidation, use Esri user-schema geodatabases <BR /> (1 oracle database - multiple geodatabases)</SPAN><BR /><BR /><STRONG><FONT size="4">SQL Server&nbsp;</FONT><BR /> </STRONG><SPAN><STRONG>SQL Server 2022 / 2019 / 2017 / 2016 (Windows/Linux)<BR /></STRONG></SPAN><SPAN>&nbsp;&nbsp;&nbsp;&nbsp; <A href="https://esriis-my.sharepoint.com/:u:/g/personal/marc3932_esri_com/EVv6D91bs05Bseza1GYlV_IB_ezj-p52-OlhS2EqNB7t7A?e=g0ePZh" target="_blank" rel="noopener nofollow noreferrer">ArcGIS Pro 3.x &amp; ArcMap 10.8.x</A> <STRONG>June</STRONG><EM><STRONG> 21, 2022</STRONG>&nbsp; <STRONG>*New</STRONG></EM></SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN><A href="https://esriis-my.sharepoint.com/:u:/g/personal/marc3932_esri_com/ESU7JvKcQzFNqEaiiGaWQ9UBXisfWEQa7bzOXksRCC3WXg?e=1W32Um" target="_blank" rel="noopener nofollow noreferrer">ArcGIS Pro 2.3 / 2.4 &amp; ArcMap 10.7 / 10.8</A> <EM>March 27, 2020&nbsp;</EM></SPAN></SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &nbsp;<A href="https://esriis-my.sharepoint.com/:u:/g/personal/marc3932_esri_com/EWYlvb1yRx1DgJd7ASUd9B4B2M7-aeqMBXIASUA_1GwUqA?e=ermzdU" target="_blank" rel="noopener nofollow noreferrer"><SPAN>ArcGIS Pro 2.2 &amp; ArcMap 10.6 / 10.5 / 10.4 / 10.3 / 10.2 / 10.1</SPAN></A> <EM>November 13, 2017</EM></SPAN><BR /><SPAN> MCS SQLServer: Step-by-step Installation of SQL Server 2016/2017 <BR /> Cluster on a Windows Server 2016 Failover Cluster<SPAN><EM><BR /></EM></SPAN></SPAN> <A href="https://esriis-my.sharepoint.com/:u:/g/personal/marc3932_esri_com/EfsGs4yfvZ1LmIhYpvwDLoUB3NpPSLRNMtGe9xQNA7lVIA?e=0hjegD" target="_blank" rel="noopener nofollow noreferrer">SQLServer Cluster on Windows Failover Cluster</A> May 11, 2018<BR /><SPAN><SPAN><EM>&nbsp;&nbsp;&nbsp;&nbsp; <A href="https://esriis-my.sharepoint.com/:b:/g/personal/marc3932_esri_com/Eb_jtFH0yrhEkQIAXRptkBYB97N_EfBp9Uw71sk4e1DKVg?e=wz8ZWb" target="_blank" rel="noopener nofollow noreferrer">How to Load a Large Featureclass in a SQL Server Geodatabase</A>&nbsp; &nbsp;Dec 03, 2020</EM></SPAN></SPAN><BR /><BR /><SPAN><FONT size="4">&nbsp;</FONT><STRONG><FONT size="4">PostgreSQL</FONT><BR />&nbsp;&nbsp; ArcGIS Pro 3.x &amp; ArcMap 10.8.x <BR /> </STRONG><A href="https://esriis-my.sharepoint.com/:u:/g/personal/marc3932_esri_com/EaaDg-0RlnBNmO9ea2irCr8BhFn-DXGkJC-VZEVIuMUeuA?e=aAdMBT" target="_blank" rel="noopener nofollow noreferrer">Postgres on Windows</A><STRONG><EM> July 05, 2023 </EM><EM>*New<BR /> </EM></STRONG><A href="https://esriis-my.sharepoint.com/:u:/g/personal/marc3932_esri_com/EX8AbN2Iu7dEmYmzTwQpngUBmyCpUC53CexN2PVHFk_bTA?e=5ulOIf" target="_blank" rel="noopener nofollow noreferrer">Postgres on Linux</A><STRONG><EM> July 05, 2023 </EM><EM>*New</EM></STRONG></SPAN><BR /><SPAN>&nbsp;&nbsp; <STRONG>ArcGIS Pro 2.3 / 2.4 &amp; ArcMap 10.7 / 10.8</STRONG></SPAN><BR /><SPAN>&nbsp;<SPAN>&nbsp;&nbsp;&nbsp; <A href="https://esriis-my.sharepoint.com/:u:/g/personal/marc3932_esri_com/EakdaDSIvZhKr36NH_YRBSUBtJhgs4I7sbSKNkLn50XyEA?e=QCAtoU" target="_blank" rel="noopener nofollow noreferrer"><SPAN>Postgres on Windows</SPAN></A> <SPAN><EM>March&nbsp;20, 2020</EM></SPAN><SPAN>&nbsp;</SPAN></SPAN></SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN><A href="https://esriis-my.sharepoint.com/:u:/g/personal/marc3932_esri_com/Eaxq5Gdh-uhIuxeFrBPVCQQBAysOpgISYBM1w7ZGcGQNPQ?e=RgS4ec" target="_blank" rel="noopener nofollow noreferrer">Postgres on Linux</A></SPAN>&nbsp;<EM>March&nbsp;20, 2020</EM>&nbsp;</SPAN><BR /><SPAN>&nbsp;&nbsp; <STRONG>ArcGIS Pro 2.2 &amp; ArcMap 10.6 / 10.5 / 10.4 / 10.3 / 10.2 / 10.1</STRONG></SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;<SPAN>&nbsp; <A href="https://esriis-my.sharepoint.com/:u:/g/personal/marc3932_esri_com/ESkv4QHzUE1OgL4O2ogJHwoBFTSzjwjG_8xOCApvEld-yw?e=jEo0FR" target="_blank" rel="noopener nofollow noreferrer"><SPAN>Postgres on Windows</SPAN></A> <EM>April 14, 2017</EM></SPAN></SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp; <A href="https://esriis-my.sharepoint.com/:u:/g/personal/marc3932_esri_com/ETKFPBatCKFHpTCPF7aICu0B39sr2B-jH0uB9r75SIUKmg?e=BIj5oQ" target="_blank" rel="noopener nofollow noreferrer"><SPAN>Postgres on Linux</SPAN></A> <EM>August 22, 2017</EM></SPAN></PRE><P><SPAN><STRONG><FONT color="#999999">________________________________________________________________________________________________</FONT></STRONG></SPAN></P><H2 id="toc-hId--1336696408"><SPAN><STRONG>Database Connections Best Practices</STRONG></SPAN></H2><PRE><SPAN><EM>1. ArcSDE Application Server ("SDE Service") is deprecated, use "direct connect".</EM></SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; - <A href="http://desktop.arcgis.com/en/arcmap/latest/get-started/introduction/whats-new-in-arcgis.htm" target="_blank" rel="noopener nofollow noreferrer"><SPAN>What's news in ArcMap 10.8 / 10.7 / 10.6 / 10.5 / 10.4 / 10.3</SPAN></A><BR /></SPAN> see Databases &amp; Geodatabases<BR /><SPAN>&nbsp;&nbsp;&nbsp; - <A href="https://pro.arcgis.com/en/pro-app/get-started/whats-new-in-arcgis-pro.htm" target="_blank" rel="noopener nofollow noreferrer"><SPAN>What's news in ArcGIS Pro</SPAN></A></SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; - <A href="https://support.esri.com/en/technical-article/000017062" target="_blank" rel="noopener nofollow noreferrer"><SPAN>Deprecation Plan for ArcGIS Products</SPAN></A></SPAN><BR /><SPAN><EM>2. Never use the "sde" user connection in: Maps (e.g. mxd's), GP tools, Map Services, <BR /> Feature Services, etc.</EM></SPAN><BR /><SPAN><EM>3. "sde" user is only for geodatabase administration (e.g. sde compress), <BR /> sde user is the geodatabase repository owner</EM></SPAN><BR /><SPAN><EM>4. Never use "data owner" user connections in: Maps (e.g. mxd's), GP tools, Map Services, <BR /> Feature Services, etc.</EM></SPAN><BR /><SPAN>&nbsp;&nbsp; - Unless really necessary to create new featureclasses or tables in the geodatabase</SPAN><BR /><SPAN>&nbsp;&nbsp; - But need to understand the implications</SPAN><BR /><SPAN>&nbsp;&nbsp; - For Geoprocessing tools always prefer file geodatabases as scratch workspaces, <BR /> its faster!!!!</SPAN><BR /><SPAN>&nbsp;&nbsp; - The problem with multiple "data owner" user connections is that this causes <BR /> table locks in the database</SPAN><BR /><SPAN>&nbsp;&nbsp; - That can lead to <STRONG>deadlocks</STRONG> and make ArcGIS Desktop (ArcMap/Pro) and <BR /> ArcGIS Server connections to halt / freeze</SPAN><BR /><SPAN>&nbsp; &nbsp;- Exception is <EM>Branch Versioning</EM>, only the data owner can publish the Feature Service</SPAN><BR /><SPAN><EM>5. How to avoid the "<STRONG>deadlock</STRONG>" issue then?</EM></SPAN><BR /><SPAN>&nbsp;&nbsp; - If not editing data in ArcGIS then use a "viewer" user connection to create the map</SPAN><BR /><SPAN>&nbsp;&nbsp; - If editing data in ArcGIS then use an "editor" user connection to create the map</SPAN><BR /><SPAN>&nbsp;&nbsp; - The "viewer" user connection has read-only (select) permission on the Featureclasses <BR /> and Tables of the "data owner" user</SPAN><BR /><SPAN>&nbsp;&nbsp; - The "editor" user connection has read-write (select, insert, update and delete) <BR /> permissions on the Featureclasses and Tables of the "data owner" user</SPAN><BR /><SPAN>&nbsp;&nbsp; - If creating ArcGIS Server Map Services use a "viewer" user connection to create <BR /> the map before it’s published</SPAN><BR /><SPAN>&nbsp;&nbsp; - If creating ArcGIS Server Feature Services use an "editor" user connection to create <BR /> the map before it’s published</SPAN><BR /><SPAN>&nbsp;&nbsp; - If creating ArcGIS Server Geoprocessing Services: if editing data use "editor" <BR /> otherwise use the "viewer" user connection<BR />6. "<STRONG>deadlock</STRONG>" explanation more details<BR />&nbsp;&nbsp; - <A href="https://oracle-base.com/articles/misc/deadlocks" target="_blank" rel="noopener nofollow noreferrer">Oracle-Base deadlocks</A> | <A href="https://docs.oracle.com/en/database/oracle/oracle-database/21/cncpt/data-concurrency-and-consistency.html#GUID-C1971E9B-849A-4634-9575-4F8FAD697750" target="_blank" rel="noopener nofollow noreferrer">Oracle Documentation deadlocks</A><BR />&nbsp;&nbsp; - <A href="https://learn.microsoft.com/en-us/sql/relational-databases/sql-server-transaction-locking-and-row-versioning-guide?view=sql-server-ver16#deadlocks" target="_blank" rel="noopener nofollow noreferrer">SQLServer Documentation deadlocks</A><BR />&nbsp;&nbsp; - <A href="https://www.postgresql.org/docs/current/explicit-locking.html#LOCKING-DEADLOCKS" target="_blank" rel="noopener nofollow noreferrer">PostgreSQL Documentation deadlocks</A></SPAN></PRE><P><STRONG><SPAN class=""><FONT color="#999999">________________________________________________________________________________________________</FONT></SPAN></STRONG></P><H2 id="toc-hId-406113927"><STRONG><SPAN class="">Database Documentation Links</SPAN></STRONG></H2><TABLE border="2"><TBODY><TR><TD><STRONG>ArcGIS System Requirements</STRONG></TD><TD><STRONG>Oracle</STRONG></TD><TD><STRONG>SQL Server</STRONG></TD><TD><P><STRONG>PostgreSQL</STRONG></P></TD></TR><TR><TD><SPAN><A title="Help: ArcGIS Pro Database System Requirements" href="https://enterprise.arcgis.com/en/system-requirements/latest/windows/database-requirements-sqlserver.htm" target="_blank" rel="nofollow noopener noreferrer">Help: ArcGIS Pro Database System Requirements</A></SPAN></TD><TD><SPAN><A href="https://docs.oracle.com/en/database/oracle/oracle-database/19/index.html" target="_blank" rel="nofollow noopener noreferrer">Help: Oracle 19c Online Documentation</A></SPAN></TD><TD>&nbsp;</TD><TD><P>&nbsp;</P></TD></TR><TR><TD><SPAN><A href="http://desktop.arcgis.com/en/system-requirements/latest/os-limits-all-platforms.htm" target="_blank" rel="nofollow noopener noreferrer">Help: 10.8 / 10.7 / 10.6 / 10.5 / 10.4 / 10.3 Database System Requirements</A></SPAN></TD><TD><SPAN><A href="https://docs.oracle.com/en/database/oracle/oracle-database/18/index.html" target="_blank" rel="nofollow noopener noreferrer">Help: Oracle 18c Online Documentation</A></SPAN></TD><TD><SPAN><A href="https://docs.microsoft.com/en-us/windows-server/get-started/hardware-requirements" target="_blank" rel="nofollow noopener noreferrer">Help: Windows Server 2019 Requirements</A></SPAN></TD><TD><P>&nbsp;</P></TD></TR><TR><TD><SPAN><A href="http://resources.arcgis.com/en/help/system-requirements/10.2/" target="_blank" rel="nofollow noopener noreferrer">Help: 10.2 Database System Requirements</A></SPAN></TD><TD><SPAN><A href="https://docs.oracle.com/database/122/index.htm" target="_blank" rel="nofollow noopener noreferrer">Help: Oracle 12.2 Online Documentation</A></SPAN></TD><TD><SPAN><A href="https://docs.microsoft.com/en-us/windows-server/get-started/hardware-requirements" target="_blank" rel="nofollow noopener noreferrer">Help: Windows Server 2016 Requirements</A></SPAN></TD><TD><SPAN><A href="http://www.postgis.org/" target="_blank" rel="nofollow noopener noreferrer">postgis.org</A></SPAN></TD></TR><TR><TD><SPAN><A href="http://resources.arcgis.com/en/help/system-requirements/10.1/#/ArcGIS_10_1_for_Desktop/015100000002000000/" target="_blank" rel="nofollow noopener noreferrer">Help: 10.1 Database System Requirements</A></SPAN></TD><TD><SPAN><A href="https://docs.oracle.com/database/121/index.htm" target="_blank" rel="nofollow noopener noreferrer">Help: Oracle 12.1 Online Documentation</A></SPAN></TD><TD><SPAN><A href="https://docs.microsoft.com/en-us/windows-server/get-started/hardware-requirements" target="_blank" rel="nofollow noopener noreferrer">Help: Windows Server 2012 R2 Requirements</A></SPAN></TD><TD><SPAN><A href="http://www.postgresql.org/" target="_blank" rel="nofollow noopener noreferrer">postgresql.org</A></SPAN></TD></TR><TR><TD><SPAN><A href="http://enterprisedev.arcgis.com/en/monitor/" target="_blank" rel="nofollow noopener noreferrer">Support: ArcGIS Monitor</A></SPAN></TD><TD><SPAN><A href="https://docs.oracle.com/cd/E11882_01/index.htm" target="_blank" rel="nofollow noopener noreferrer">Help: Oracle 11.2 Online Documentation</A></SPAN></TD><TD><SPAN><A href="https://docs.microsoft.com/en-us/sql/sql-server/install/hardware-and-software-requirements-for-installing-sql-server-2019?view=sql-server-ver15" target="_blank" rel="nofollow noopener noreferrer">Help: SQL Server Requirements and older</A></SPAN></TD><TD><SPAN><A href="http://www.enterprisedb.com/" target="_blank" rel="nofollow noopener noreferrer">enterprisedb.com</A></SPAN></TD></TR><TR><TD><SPAN><A href="http://support.esri.com/en/" target="_blank" rel="nofollow noopener noreferrer">Support: Esri Support</A></SPAN></TD><TD><SPAN><A href="https://docs.oracle.com/cd/B28359_01/index.htm" target="_blank" rel="nofollow noopener noreferrer">Help: Oracle 11.1 Online Documentation</A></SPAN></TD><TD><SPAN><A href="https://docs.microsoft.com/en-us/sql/sql-server/?view=sql-server-ver15" target="_blank" rel="nofollow noopener noreferrer">Help: SQL Server Books Online</A></SPAN></TD><TD><SPAN><A href="https://www.pgbarman.org/" target="_blank" rel="nofollow noopener noreferrer">pgbarman.org</A></SPAN></TD></TR><TR><TD><SPAN><A href="http://www.arcgis.com/home/item.html?id=a269d03aa1c840638680e2902dadecac" target="_blank" rel="nofollow noopener noreferrer">Support: mxdperfstat</A></SPAN></TD><TD><SPAN><A href="https://docs.oracle.com/cd/B19306_01/nav/portal_1.htm" target="_blank" rel="nofollow noopener noreferrer">Help: Oracle 10g Online Documentation</A></SPAN></TD><TD>&nbsp;</TD><TD><SPAN><A href="https://odbc.postgresql.org/" target="_blank" rel="nofollow noopener noreferrer">odbc.postgresql.org</A></SPAN></TD></TR><TR><TD><SPAN><A href="https://blogs.esri.com/esri/arcgis/2017/01/05/perfqanalyzer-new-10-5-version-build172-available-for-download/" target="_blank" rel="nofollow noopener noreferrer">Support: PerfQAnalyzer</A></SPAN></TD><TD><SPAN><A href="http://support.oracle.com/" target="_blank" rel="nofollow noopener noreferrer">Support: MOS - My Oracle Support</A></SPAN></TD><TD>&nbsp;</TD><TD><SPAN><A href="https://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling" target="_blank" rel="nofollow noopener noreferrer">Replication, Clustering and Connection_Pooling</A></SPAN></TD></TR><TR><TD><SPAN><A href="http://training.esri.com/gateway/index.cfm?fa=search.results&amp;searchterm=geodatabase" target="_blank" rel="nofollow noopener noreferrer">Training: Geodatabase</A></SPAN></TD><TD><SPAN><A href="http://www.oracle.com/technology/index.html" target="_blank" rel="nofollow noopener noreferrer">Support: OTN - Oracle Technology Network</A></SPAN></TD><TD><A href="https://docs.microsoft.com/en-us/sql/database-engine/install-windows/latest-updates-for-microsoft-sql-server?view=sql-server-ver15" target="_self" rel="nofollow noopener noreferrer"><SPAN>Support - SQL Server Update Center</SPAN></A></TD><TD><SPAN><A href="https://sourceforge.net/p/pg-rman/wiki/User%27s_Manual/" target="_blank" rel="nofollow noopener noreferrer">pg_rman</A></SPAN></TD></TR><TR><TD><SPAN><A href="http://server.arcgis.com/en/server/latest/cloud/amazon/enterprise-geodatabases-in-sql-server-in-arcgis-server-on-aws.htm" target="_blank" rel="nofollow noopener noreferrer">Help: 10.x Geodatabase in Amazon RDS SQL Server</A></SPAN></TD><TD><SPAN><A href="http://www.oracle.com/technetwork/indexes/downloads/index.html#database" target="_blank" rel="nofollow noopener noreferrer">Support: Oracle Downloads</A></SPAN></TD><TD><SPAN><A href="http://support.microsoft.com/" target="_blank" rel="nofollow noopener noreferrer">Support: Microsoft Support</A></SPAN></TD><TD><SPAN><A href="https://www.pgadmin.org/" target="_blank" rel="nofollow noopener noreferrer">pgadmin</A></SPAN></TD></TR><TR><TD><SPAN><A href="http://server.arcgis.com/en/server/latest/cloud/amazon/geodatabases-in-postgresql-included-with-arcgis-server-on-amazon-ec2.htm" target="_blank" rel="nofollow noopener noreferrer">Help: 10.x Geodatabase in Amazon RDS PortgreSQL</A></SPAN></TD><TD><SPAN><A href="http://www.toadworld.com/" target="_blank" rel="nofollow noopener noreferrer">Support: TOAD World</A></SPAN></TD><TD><SPAN><A href="http://www.sqlservercentral.com/" target="_blank" rel="nofollow noopener noreferrer">Support: SQL Server Central</A></SPAN></TD><TD>&nbsp;</TD></TR><TR><TD><SPAN><A href="http://server.arcgis.com/en/server/latest/cloud/azure/add-registered-databases.htm" target="_blank" rel="nofollow noopener noreferrer">Help: 10.x Geodatabase in Azure SQL Database</A></SPAN></TD><TD><SPAN><A href="https://apex.oracle.com/pls/apex/f?p=44785:141:115845291228397::::P141_PAGE_ID%2CP141_SECTION_ID:6%2C18" target="_blank" rel="nofollow noopener noreferrer">Training: Oracle Learning Library</A></SPAN></TD><TD><SPAN><A href="http://msdn.microsoft.com/en-us/sqlserver/default.aspx" target="_blank" rel="nofollow noopener noreferrer">Support: MSDN - SQL Server Developer Center</A></SPAN></TD><TD>&nbsp;</TD></TR><TR><TD><SPAN><A href="https://enterprise.arcgis.com/en/cloud/" target="_blank" rel="nofollow noopener noreferrer">Help: 10.x ArcGIS for Server on Cloud Platforms</A></SPAN></TD><TD><SPAN><A href="http://oracle-base.com/" target="_blank" rel="nofollow noopener noreferrer">Training: Oracle-Base ( Tim Hall, OCM )</A></SPAN></TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD><SPAN><A href="http://samplecode.oracle.com/" target="_blank" rel="nofollow noopener noreferrer">Training: samplecode.oracle.com</A></SPAN></TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD><A href="https://community.esri.com/t5/implementing-arcgis-blog/what-is-egdbhealth/ba-p/886466" target="_blank"><SPAN>What is Egdbhealth?</SPAN></A></TD><TD><SPAN><A href="http://www.onlinevideolecture.com/" target="_blank" rel="nofollow noopener noreferrer">Training: onlinevideolecture ebooks</A></SPAN></TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD><A href="https://community.esri.com/t5/implementing-arcgis-blog/using-egdbhealth-to-evaluate-a-geodatabase/ba-p/886488" target="_blank"><SPAN>Using Egdbhealth to Evaluate a Geodatabase</SPAN></A></TD><TD><SPAN><A href="http://www.baarf.com/" target="_blank" rel="nofollow noopener noreferrer">Storage: BAARF</A></SPAN></TD><TD>&nbsp;</TD><TD><P>&nbsp;</P></TD></TR><TR><TD>&nbsp;</TD><TD><SPAN><A href="http://www.baarf.dk/BAARF/0.Millsap1996.08.21-VLDB.pdf" target="_blank" rel="noopener nofollow noreferrer">Storage: Configuring Oracle Server for VLDB - Cary Millsap</A></SPAN></TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD><SPAN><A href="https://docs.oracle.com/en/database/oracle/oracle-database/19/dblic/Licensing-Information.html#GUID-0F9EB85D-4610-4EDF-89C2-4916A0E7AC87" target="_blank" rel="noopener nofollow noreferrer">Oracle 19c Licensing</A></SPAN></TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD><SPAN><A href="https://docs.oracle.com/en/database/oracle/oracle-database/18/dblic/Licensing-Information.html#GUID-B6113390-9586-46D7-9008-DCC9EDA45AB4" target="_blank" rel="noopener nofollow noreferrer">Oracle 18c Licensing</A></SPAN></TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD><SPAN><A href="https://docs.oracle.com/en/database/oracle/oracle-database/12.2/dblic/Licensing-Information.html#GUID-0F9EB85D-4610-4EDF-89C2-4916A0E7AC87" target="_blank" rel="noopener nofollow noreferrer">Oracle 12c Licensing</A></SPAN></TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD><A href="https://docs.oracle.com/cd/E11882_01/license.112/e47877/editions.htm#DBLIC109" target="_blank" rel="noopener nofollow noreferrer">Oracle 11gR2 Licensing</A></TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD><A href="https://www.oracle.com/corporate/pricing/" target="_blank" rel="noopener nofollow noreferrer">Pricing</A></TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD><A href="https://support.esri.com/en/technical-article/000018063" target="_blank" rel="noopener nofollow noreferrer">How To: Perform schema restores of an Oracle enterprise geodatabase</A></TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD><A href="https://support.esri.com/en/technical-article/000009852" target="_blank" rel="noopener nofollow noreferrer">FAQ: Working with ST_Geometry and Oracle export/import</A></TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P><FONT color="#999999">________________________________________________________________________________________________</FONT></P><H2 id="toc-hId--2146043034"><STRONG><SPAN class="">Database Storage Best Practices</SPAN></STRONG></H2><H3 id="toc-hId-2094783238"><SPAN class="">Why to use Multiple Tablespaces and RAID 10</SPAN></H3><PRE><SPAN>• Large production enterprise geodatabase systems should employ a hardware striping solution.<BR /> Your best disk and data organization strategies involve spreading your data across <BR /> multiple disks.</SPAN><BR /><SPAN>• With data spread across multiple disks, more spindles actively search for it. <BR /> This can increase disk read time and decrease disk contention.</SPAN><BR /><SPAN>• There are two main ways of achieving striping: tablespaces and redundant array of <BR /> independent disks (RAID).</SPAN><BR /><SPAN>• You can also combine the two by creating tablespaces within disk arrays.</SPAN><BR /><SPAN>• You can employ data segregation strategies; keeping tables from indexes or certain types <BR /> of tables from other tables will improve performance and alleviate administrative burdens.</SPAN><BR /><SPAN>• Standard GIS storage recommendations favor keeping index and log files separate from <BR /> vector and tabular business tables.</SPAN><BR /><SPAN>• For performance reasons, it is better to position the business, feature, and spatial index<BR /> tables separately and position tablespace data files based on their usage pattern.</SPAN><BR /><SPAN>• For a multiversioned, highly active editing geodatabase, database files of the VERSIONS <BR /> tablespace may be separated and dispersed across available disks to avoid I/O contention.</SPAN><BR /><SPAN>• As a rule, you should create database files as large as possible based on the maximum <BR /> amount of data you estimate the database will contain to accommodate future growth.</SPAN><BR /><SPAN>• By creating large files, you can avoid file fragmentation and gain better <BR /> database performance.</SPAN><BR /><SPAN>• In many cases, you can allow data files to grow automatically; just be sure to <BR /> limit autogrowth by specifying a maximum growth size that leaves some available <BR /> hard disk space.</SPAN><BR /><SPAN>• By putting different tablespaces on different disks, you can also help eliminate physical <BR /> fragmentation of your files as they grow.</SPAN></PRE><H3 id="toc-hId--457373723"><SPAN class=""><A href="http://www.baarf.com/" target="_blank" rel="nofollow noopener noreferrer">BAARF - Battle Against Any RAID 5</A></SPAN></H3><H3 id="toc-hId-1285436612"><SPAN class=""><A href="http://www.baarf.dk/BAARF/0.Millsap1996.08.21-VLDB.pdf" target="_blank" rel="nofollow noopener noreferrer">Configuring Oracle Server for VLDB - Cary Millsap, Oracle</A></SPAN></H3><PRE><EM><STRONG>Famous white paper!!!!!</STRONG></EM><BR /><SPAN>• Fine-grained striping can be a bad choice for the tablespaces to which Oracle Server <BR /> writes sort segments if a lot of applications processes will be sorting simultaneously. <BR /> Fine-grained striping can a so yield surprisingly bad results for applications that <BR /> use the Oracle's parallel query optimization (PQO) feature, because PQO's use of multiple <BR /> query slaves manufactures its own high concurrency level even for a single user session.</SPAN><BR /><SPAN>• If your database contains one or more small tablespaces for which large raw slices <BR /> would be wasteful, you may wish to select one or two more standard raw slice sizes for <BR /> those tablespaces. If you use more than one raw slice size, then make the sizes integral <BR /> multiples and divisors of each other.</SPAN><BR /><SPAN>• I/O performance—Each tablespace should contain segments whose I/O concurrency and I/O size<BR /> characteristics are similar, to facilitate disk array size and stripe size selection. <BR /> Grouping read-only segments into read-only tablespaces reduces backup and recovery data <BR /> transfer volumes and reduces PCM lock maintenance.</SPAN><BR /><SPAN>• Outage resilience—Small tablespaces allow offline tablespace maintenance with minimal <BR /> application outage. The system tablespace cannot be taken off-line, and it cannot be <BR /> dropped and recreated, so keeping as few segments there as possible minimizes the need <BR /> for database downtime. Isolating rollback segments into as few tablespaces as possible <BR /> reduces outage frequency, because any tablespace containing an on-line rollback segment <BR /> cannot be taken off-line. Storing referentially related segments in small groups of <BR /> tablespaces maximizes your ability to exploit the tablespace point-in-time <BR /> recovery feature.</SPAN><BR /><SPAN>• Space management—Isolating segments with short lifespans minimizes the impact of tablespace<BR /> free space fragmentation that can block Oracle Server extent allocation. <BR /> VLDB administrators profit from using tablespace default storage parameters instead of <BR /> maintaining segment sizing parameters at the segment level.</SPAN><BR /><SPAN>• Quota management—Oracle Server space quotas are administered to users by tablespace. <BR /> Hence, you should assign groups of segments in one schema to a small group of tablespaces.</SPAN><BR /><SPAN>• If you are using fine-grained striping for data files, then it is not necessary to <BR /> separate indexes from data to distribute I/O load across disks. <BR /> However, if your operational procedures include periodic index rebuilds, <BR /> you may want to consider isolating indexes into their own tablespaces to minimize the <BR /> possible impact of tablespace free space fragmentation caused by the drop index.</SPAN></PRE><H3 id="toc-hId--1266720349"><SPAN class=""><A href="http://www.baarf.dk/BAARF/oow2000_same.pdf" target="_blank" rel="nofollow noopener noreferrer">Optimal Storage Configuration Made Easy - Juan Loaiza, Oracle</A></SPAN></H3><PRE><SPAN>• This methodology assigns a specific load to various subsets of the database such as <BR /> log files, rollback segments, index tablespaces, data tablespaces, etc. and <BR /> assigns disks to these subsets based on their load profile.</SPAN></PRE><P><FONT color="#999999">________________________________________________________________________________________________</FONT></P><P><SPAN>An Esri ® Technical Reference February• 2026</SPAN></P><P><SPAN><FONT color="#999999">________________________________________________________________________________________________</FONT></SPAN></P> Thu, 26 Feb 2026 06:33:52 GMT ShareUser 2026-02-26T06:33:52Z https://community.esri.com/t5/arcgis-utility-network-questions/mapping-and-charting-solutions-mcs-enterprise/m-p/1396165#M4402 <P><STRONG>Mapping &amp; Charting Solutions (MCS) Enterprise Databases Best Practices</STRONG></P><P><SPAN>Intended&nbsp;for database administrators as recommendations for establishing the product workspaces in an Enterprise Geodatabase (Oracle®, SQL Server®, PostgreSQL®).</SPAN></P> Thu, 26 Feb 2026 06:33:52 GMT https://community.esri.com/t5/arcgis-utility-network-questions/mapping-and-charting-solutions-mcs-enterprise/m-p/1396165#M4402 ShareUser 2026-02-26T06:33:52Z