RE: db_file_multiblock_read_count and performance

What did you expect to see in 10046 file?

-----Original Message-----

From: ryan_gaffuri_at_comcast.net [mailto:ryan_gaffuri_at_comcast.net]=20 Sent: Monday, December 06, 2004 12:21 PM To: Oracle-L_at_freelists.org
Subject: db_file_multiblock_read_count and performance

I have been testing this extensively over the last few months. I do a full table scan with a db_file_multiblock_read_count =3D 1 and then one = =3D
128( i check the 10046 trace to verify i am getting this much) and I see absolutely no difference whatsoever in response time.=20 i am doing=20
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
--

http://www.freelists.org/webpage/oracle-l Received on Mon Dec 06 2004 - 13:31:55 CST