One of our users has been periodically experiencing
Out of Server Memory errors with ArcSDE 10.0 when trying to reconcile a large edit session.
VMware ESX Instance:
Windows Server 2008 R2 Datacenter
Service Pack 1
Intel Xeon E5-2660 @ 2.20GHz
8 GB RAM
I've set up a performance monitor to track memory usage but I'm curious if this is a problem anybody else has experienced with versioned editing?
Our RDBMS is Oracle and I have found this page by ESRI:
However, this seems to assume that ArcSDE and Oracle are on the same machine (for us they are not). Should I remove the 'unlimited' table space associated with the editing user?
Also, we make direct connections to your database using the Oracle client. Does this mean that I'm perhaps looking at the wrong server (ArcSDE) and should be speaking with the DBAs ? I'm thinking ArcObjects error means ArcSDE problem but perhaps somebody can correct me on this?
Solution seemed to be to enable 64-bit background GP on the desktop who was responsible for editing. Large edit sessions seemed to cause problems with our Oracle Geodatabase. Likely could have been resolved at the RDBMS level but DBAs were unavailable at the time to troubleshoot.