Hello,
I am trying to estimate the time it will take to do a table reorg. I checked the awr reports and tried to use the values for physical read bytes/second to estimate the time it takes to read the original table (blocks*block size) and the value for physical write bytes to estimate the time it takes to write the new version of the table (rows * avg row length). However this method does not give the correct results, it greatly overestimates the speed of the reorg. I don't have the privileges to execute DBMS_RESOURCE_MANAGER.calibrate_io. Also, I can't use the speed of one re-org to estimate the speed of another as I need to estimate the time it takes prior to the first re-org. That is why I am trying to come up with an accurate method to estimate on a server that is not in production.
Is there a more precise method?
Thank you very much