Slow performance on Oracle GDB

494
2
11-14-2016 04:00 AM
Highlighted
New Contributor III

Recently we fully compressed our Oracle GDB to bring it back to STATE 0. Later updated STATS and Rebuilt Indexes. But now users are complaining for slow performance while editing and saving.

One of feature of type Annotation is extremely slow while edit and save. Please suggest on how we can improve performance.

Reply
0 Kudos
2 Replies
Highlighted
MVP Esteemed Contributor

The more information you can provide, the better feedback you will likely get from folks.  For example, what version of Oracle and ArcGIS for Server/ArcSDE?  What version of ArcGIS clients?  Are all the feature classes slow or just a few?  Since compressing doesn't guarantee State 0, how did you verify you are back to State 0?

Reply
0 Kudos
Highlighted
New Contributor III

Not sure how it was causing slowness but after compressing the gdb AGAIN the issue seems to be solved. Only one of FC was culprit..

After compressing the GDB, I used to query SDE.COMPRESS_LOG to check compression status and SDE.VERSIONS table to check the DEFAULT state. From there I finds STATE_ID of the default version.  

Thank you for your assistance.

Reply
0 Kudos