Re: db_file_multiblock_read_count and performance

The optimal setting for FTS varies between platforms.

See http://www.ixora.com.au/scripts/sql/multiblock_read_test.sql for help in determining the correct setting.

Jared

On Mon, 06 Dec 2004 17:20:50 +0000, ryan_gaffuri_at_comcast.net <ryan_gaffuri_at_comcast.net> wrote:
> I have been testing this extensively over the last few months. I do a full table scan with a db_file_multiblock_read_count = 1 and then one = 128( i check the 10046 trace to verify i am getting this much) and I see absolutely no difference whatsoever in response time.
> i am doing
> select count(*)
> from heap_table;
> I have tested this on windows xp, solaris, with EMC, netapp, and regular old cheap off the shelf hard drives. I have tested it in 8.1.7, 9.0,9.1,9.2.
> has anyone see a response time improvement from this parameter anywhere?
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l