RE: db_file_multiblock_read_count and performance
- From: "Post, Ethan" <Ethan.Post@xxxxxx>
- To: <ryan_gaffuri@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 7 Dec 2004 09:48:32 -0600
I think the test cases showed that it does change performance. Can you
post your actual test cases with plans and stats?
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
ryan_gaffuri@xxxxxxxxxxx
Sent: Tuesday, December 07, 2004 9:05 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: db_file_multiblock_read_count and performance
To those of you who posted test cases with different level of
performance based on the DFMRC. Did your query plan change? I know this
parameter can affect query plans, but if you are doing a straight full
table scan, I did not notice any performance difference with different
settings. I only noticed differences if my plan changed.=20
I was looking to test whether it actually increases the pipe to the hard
drive.=20
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
