Re: sequential read on full-table scan?

OOps, in case anyone wonders how I come to a cost calculation of 1152/16 and 1152/3 for a 1024 block table. The explanation is that I had started with 1024 but by the time I got to 1024/3=341.33333 I thought it would be simpler to avoid the decimals and switched the calculations to a 1152 block table, except I forgot to make that change in the first line.

At 11:45 PM 5/20/2005, Wolfgang Breitling wrote:

>e.g. for a table of 1024 blocks
>
>with a dfmrc of 16: cost of FTS = 1152/16 = 72 ( + 1 for
>_table_scan_cost_plus_one = true) = 73
>with a real mbrc of 3: cost of FTS = 1152/3 = 384 ( + 1 for
>_table_scan_cost_plus_one = true) = 385

Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com

--
http://www.freelists.org/webpage/oracle-l