Re: db_file_multiblock_read_count and performance
- From: ryan_gaffuri@xxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 07 Dec 2004 15:05:22 +0000
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.
I was looking to test whether it actually increases the pipe to the hard drive.
--
http://www.freelists.org/webpage/oracle-l
- Follow-Ups:
- Re: db_file_multiblock_read_count and performance
- From: Wolfgang Breitling
- Re: db_file_multiblock_read_count and performance
- From: Jared Still
Other related posts:
- » db_file_multiblock_read_count and performance
- » RE: db_file_multiblock_read_count and performance
- » RE: db_file_multiblock_read_count and performance
- » Re: db_file_multiblock_read_count and performance
- » RE: db_file_multiblock_read_count and performance
- » RE: db_file_multiblock_read_count and performance
- » RE: db_file_multiblock_read_count and performance
- » RE: db_file_multiblock_read_count and performance
- » Re: db_file_multiblock_read_count and performance
- » RE: db_file_multiblock_read_count and performance
- » RE: db_file_multiblock_read_count and performance
- » RE: db_file_multiblock_read_count and performance
- » RE: db_file_multiblock_read_count and performance
- » RE: db_file_multiblock_read_count and performance
- » RE: db_file_multiblock_read_count and performance
- » Re: db_file_multiblock_read_count and performance
- » Re: db_file_multiblock_read_count and performance
- » RE: db_file_multiblock_read_count and performance
- » Re: db_file_multiblock_read_count and performance
- » RE: db_file_multiblock_read_count and performance
- » RE: db_file_multiblock_read_count and performance
- » Re: db_file_multiblock_read_count and performance
- » Re: db_file_multiblock_read_count and performance
- » Re: db_file_multiblock_read_count and performance
- » Re: db_file_multiblock_read_count and performance
- » RE: db_file_multiblock_read_count and performance
- » RE: db_file_multiblock_read_count and performance
- » Re: db_file_multiblock_read_count and performance
- » Re: db_file_multiblock_read_count and performance
- » RE: db_file_multiblock_read_count and performance
- » RE: db_file_multiblock_read_count and performance
- Re: db_file_multiblock_read_count and performance
- From: Wolfgang Breitling
- Re: db_file_multiblock_read_count and performance
- From: Jared Still