RE: db_file_multiblock_read_count causing full scans to takelonger?
- From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- To: <kevinc@xxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 19 Dec 2006 16:56:44 -0700
FS in both the HPUX and AIX cases that I'm testing. I'm using CIO for
Oracle (10.2 w/filesystemio_options=setall), but the filesystem is not
mounted with o=cio or dio.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Kevin Closson
Again, are we talking FS or Direct I/O with these cases where greater
than 255KB seems to cause big problems?
Privileged/Confidential Information may be contained in this message or
attachments hereto. Please advise immediately if you or your employer do not
consent to Internet email for messages of this kind. Opinions, conclusions and
other information in this message that do not relate to the official business
of this company shall be understood as neither given nor endorsed by it.
--
http://www.freelists.org/webpage/oracle-l
- References:
- RE: db_file_multiblock_read_count causing full scans to takelonger?
- From: Kevin Closson
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: Kevin Closson