when dbms_stats.gather_system_stats is run then time to read a single block , and time to read multiple blocks at one time is stored is aux_stats$ table, which is used by the optimizer. Kevin Closson <kevinc@xxxxxxxxxxxxx> wrote: >>As currently the optimizer uses the single block read time and multiblock read time. what? -- //www.freelists.org/webpage/oracle-l