Under Quest SQL Optimizer for Oracle, Options | Optimize SQL | Best Practices | Table, what does "Ratio of smallest partition to the largest partition is less than (%)" means? How is it being calculated.
The smallest and largest number are obtained by checking the number of bytes allocated to each partition of the table.
"Ratio of smallest partition to the largest partition is less than (%)" means the value that determines whether Best Practices recommends you change the partitioning size setting. Default is 40%.