| Mark A. Parsons 2005-04-09, 8:26 pm |
| Take a look at the systabstats system table. There are 4 reorg-related
columns (rslast*, frlast*) in the table. These columns won't tell you
exactly what you're looking for but with other tidbits (eg, number of OAM
pages in database, number of data/leaf pages in a table/index, etc) you may
be able to come up with a rough estimate.
Another option would be enable stats io before you kick off reorg ... then
compare the resultant io stats with known size of table in question. [I'm
assuming you can capture the number of io's for a reorg command; haven't
actually tried it myself.]
César, Buzzo wrote:
> I have a big table (15 GB) that I reorganize partially every
> night with the command REORG COMPACT mytable WITH RESUME,
> TIME = 15. Unfortunately I don't know the percentage of
> the table that it was reorganized after each execution. In
> the errorlog appears the message REORG COMPACT mytable
> COMPLETED although the table wasn't completly reorganized.
> Does anybody know a way to know the percentage of the work
> already done by this command ? I need to predict the time
> that it will take a whole reorganization of the table.
>
> Thanks
> César
|