The value for parameter ESTIMATE is either BLOCKS (default) or STATISTICS. BLOCKS: The estimated space used is calculated by multiplying the number of database blocks used by the target objects with the appropriate block sizes. It is the least accurate because of: The table was created with a much bigger initial extent size than was needed for […]