Re: db_file_multiblock_read_count and performance

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: ryan_gaffuri@xxxxxxxxxxx
  • Date: Tue, 7 Dec 2004 07:47:40 -0800

Since the table was created with out indexes,
and the SQL was hinted to FULL(), there really
was no choice other than FTS.

On Tue, 07 Dec 2004 15:05:22 +0000, ryan_gaffuri@xxxxxxxxxxx
<ryan_gaffuri@xxxxxxxxxxx> wrote:
> 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.
> --

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Other related posts: