Forum Stats

  • 3,837,076 Users
  • 2,262,223 Discussions
  • 7,900,198 Comments

Discussions

Time require to perform shrink operation

ProDBA
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?