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.
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
//www.freelists.org/webpage/oracle-l
Other related posts:
