To do a regular ArcSDE Geodatabase Maintenance, you need to do the following:
- Rebuild Indexes (you can use python scripting for ArcGIS 10.1)
- Analyze (update statistics) (you can use python scripting for ArcGIS 10.1)
- 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.
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:
This is the “12c Database Architecture Image Diagram” for reference.
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.
This Image shows the diagram of the new Oracle 12c Multitenant Architecture.
The Multitenant Architecture is a “cloud – based” architecture, which is a new shift in Oracle RDBMS management.
this is my first post in my blog ……hopefully you benefit from my blog in GIS and Database technologies.