Compaction of Large globals
I would like to Compact globals in a database to free up space.
I would begin the process on Saturday morning, but am concerned, due to the size, that it would not complete by Sunday evening. I understand that the process is setup so that it can run with users on the system, however, as the advice indicates, this would not be ideal.
Can the process be stopped if it does not complete by the time you want/need it to?
Do you know how to guestimate how long the process would take?
This is the Freespace for the database in question. There are 1047 globals of which one of them takes up 50%.
Max Size Size Available %Free Disk Free
Unlimited 1.838TB 279.90GB 14.87 254.37GB