SDE Compress triples size of geodatabase

[TimAnderson3]

My plan is to load roughly 400gb of vector data into an enterprise geodatabase. I just recently got started, and let "compress geodatabase" run over night. When I came back in, my SDE had grown from 4gb to about 16gb after the compress completed. I am using Desktop 10.6 and Oracle 12.2. If compressing increases size 2-3x this is going to give me problems. any suggestions on what may be broken?

[TimAnderson3]

thanks! i will give this a shot in the morning. Our Oracle guru should be back to work by then as well. Hopefully he can help me sort this out, as I am a novice with Oracle at best. 

[midettra]

Hello Tim,

I know this is an old post, but I am facing the same problem you had. The enterprise database size was 5.5 GB before compress and after compress it reached 6.3 GB and I did not figure out why did this happen and also would this have any negative impact on the performance ?! 

I am using Arcmap 10.7 with SQL server 2014. The state_id number was around 7,000 and ended up to 14 after compress. I walked through all the procedures for a full compress starting with posting changes and deleting versions reaching to disconnecting all users.

Kindly your response is much appreciated if you found a reason for this issue.

Thank you,

Mohamed Salah