Forum Stats

  • 3,872,137 Users
  • 2,266,392 Discussions


Time require to perform shrink operation

ProDBA Member Posts: 120 Blue Ribbon

We have executed the segment advisor and got recommendation[s] as follows:

For a table: Enable row movement of the table schema.table and perform shrink, estimated savings is 6227645760 bytes.
For an index: Perform shrink, estimated savings is 3707377718 bytes.

We want to estimate the time and inform the customer that for this table we need x hours. How we can estimate the time?