Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: db_file_multiblock_read_count and performance

RE: db_file_multiblock_read_count and performance

From: Post, Ethan <Ethan.Post_at_ps.net>
Date: Tue, 7 Dec 2004 09:48:32 -0600
Message-ID: <83FCA77436D6A14883E132C63F4101D001DCC977@pscdalpexch50.perotsystems.net>


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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of ryan_gaffuri_at_comcast.net
Sent: Tuesday, December 07, 2004 9:05 AM To: oracle-l_at_freelists.org
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
--

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

http://www.freelists.org/webpage/oracle-l Received on Tue Dec 07 2004 - 09:54:45 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US