ArcSDE Geodatabase Maintenance

To do a regular ArcSDE Geodatabase Maintenance, you need to do the following:

 

  1. Rebuild Indexes (you can use python scripting for ArcGIS 10.1)
  2. Analyze (update statistics) (you can use python scripting for ArcGIS 10.1)
  3. Compress (you can either use ArcCatalog 10.1 , Command Line, or Python)

 

of course to perform the listed activities you need to have all connections disconnected , which could be a problem if you want to perform maintenance in a “production” environment.

you can schedule these activities either daily or weekly, depends wither your environment is intensive in “editing”, since you will be having a lot of versions.

From practice, ArcSDE Compress will give optimum results when the editors are performing Reconcile and POST and delete their versions. Otherwise, you will not benefit a lot from the compress operation.

Advertisement

Execute privileges on required Oracle builtin package DBMS_UTILITY must be granted directly to the SDE DBA user, granting them a ROLE with execute access is insufficient. ERROR in checking system st_geometry type (-25).

check my esri forum thread replay: http://forums.arcgis.com/threads/60398-ArcSDE-execute-privilege-be-removed-from-public-on-Oracle-packages?p=329097#post329097

 

be careful in the order of executing the steps.

 

granting the following packages to “PUBLIC” role is always a security issue:

 

dbms_pipe 
dbms_lock 
dbms_lob 
dbms_utility
dbms_sql 
utl_raw

ArcGIS 10.2 Deprecation plan

you can find the deprecation plan here: http://downloads2.esri.com/support/TechArticles/W26496_W25918_DEPRECATION_PLAN_FOR_ARCGIS_101_and_102_FINAL_050713.pdf

REMARK: ArcGIS 10.2 will be the last for ArcSDE as an “application server”. This means companies/organizations using ArcSDE tehcnology as an application server, should start migrating to “Direct Connection” , which is a 2-tier architecture.