Re: db_file_multiblock_read_count and performance
- From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
- To: ryan_gaffuri@xxxxxxxxxxx
- Date: Tue, 07 Dec 2004 08:34:33 -0700
If you read my post you should have seen that the extract from the
tkprof output of my testcases showed the query plans and it was a FTS in
both cases. There was no other plan available anyway since the single
table in the sql didn't have any indexes.
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
>
--
Regards
Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
