RE: db_file_multiblock_read_count and performance
- From: "Post, Ethan" <Ethan.Post@xxxxxx>
- To: <breitliw@xxxxxxxxxxxxx>, <ryan_gaffuri@xxxxxxxxxxx>
- Date: Mon, 6 Dec 2004 14:31:21 -0600
I think what he is trying to prove is that given two full table scans
one should perform faster by adjusting the size of the multiblock reads.
The right questions might be....
1) Is DBMRC informative in nature only (tells Oracle what the actual
read count size is for OS)?
or
2) Does DBMRC actually influence the size of read count at IO level?
=20
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Wolfgang Breitling
Sent: Monday, December 06, 2004 1:50 PM
To: ryan_gaffuri@xxxxxxxxxxx
Cc: Oracle-L@xxxxxxxxxxxxx
Subject: Re: db_file_multiblock_read_count and performance
Yes, I certainly have. I used it in conversion programs where I knew=20
that a lot of full scans were performed.
ryan_gaffuri@xxxxxxxxxxx wrote:
> has anyone see a response time improvement from this parameter
anywhere?=20
--=20
Regards
Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
