RE: db_file_multiblock_read_count causing full scans to takelonger?
- From: "Kevin Closson" <kevinc@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 19 Dec 2006 15:47:54 -0800
>>>at that point, but I would expect the difference to occur at
>>>257k, not 256k - and I wouldn't expect it to be such a big
>>>difference. You'd think HPUX could split up the larger read
>>>requests into 255k chunks a little more efficiently than that.
>>>I'll check on a couple more AIX and HPUX systems and see if
>>>they exhibit the same behavior too.
Again, are we talking FS or Direct I/O with these cases where
greater than 255KB seems to cause big problems?
--
http://www.freelists.org/webpage/oracle-l
- Follow-Ups:
- RE: db_file_multiblock_read_count causing full scans to takelonger?
- From: Allen, Brandon
- References:
- RE: db_file_multiblock_read_count causing full scans to takelonger?
- From: Allen, Brandon
Other related posts:
- » RE: db_file_multiblock_read_count causing full scans to takelonger?
- » RE: db_file_multiblock_read_count causing full scans to takelonger?
- » RE: db_file_multiblock_read_count causing full scans to takelonger?
- » Re: db_file_multiblock_read_count causing full scans to takelonger?
- » RE: db_file_multiblock_read_count causing full scans to takelonger?
- » RE: db_file_multiblock_read_count causing full scans to takelonger?
- » RE: db_file_multiblock_read_count causing full scans to takelonger?
- » RE: db_file_multiblock_read_count causing full scans to takelonger?
- » RE: db_file_multiblock_read_count causing full scans to takelonger?
- » RE: db_file_multiblock_read_count causing full scans to takelonger?
- » RE: db_file_multiblock_read_count causing full scans to takelonger?
- » RE: db_file_multiblock_read_count causing full scans to takelonger?
- » RE: db_file_multiblock_read_count causing full scans to takelonger?
- » RE: db_file_multiblock_read_count causing full scans to takelonger?
- » RE: db_file_multiblock_read_count causing full scans to takelonger?
- » RE: db_file_multiblock_read_count causing full scans to takelonger?
- » RE: db_file_multiblock_read_count causing full scans to takelonger?
- » RE: db_file_multiblock_read_count causing full scans to takelonger?
- » RE: db_file_multiblock_read_count causing full scans to takelonger?
- » RE: db_file_multiblock_read_count causing full scans to takelonger?
- » RE: db_file_multiblock_read_count causing full scans to takelonger?
- » RE: db_file_multiblock_read_count causing full scans to takelonger?
- RE: db_file_multiblock_read_count causing full scans to takelonger?
- From: Allen, Brandon
- RE: db_file_multiblock_read_count causing full scans to takelonger?
- From: Allen, Brandon