RE: I/O and db_file_multiblock_read_count
- From: "Kevin Closson" <kevinc@xxxxxxxxxxxxx>
- To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 11 Dec 2006 12:51:03 -0800
well, just eyeballing the math...it looks
like 93% less trips into the kernel and
an approximate 85% reduction in system time.
looks about right to me...
>>>
>>>Strangely, the sys time is much lower with the 1M blocksize.
>>>Is there an explanation for that?
>>>
>
--
http://www.freelists.org/webpage/oracle-l
- References:
- RE: I/O and db_file_multiblock_read_count
- From: Keith Moore
Other related posts:
- » I/O and db_file_multiblock_read_count
- » RE: I/O and db_file_multiblock_read_count
- » Re: I/O and db_file_multiblock_read_count
- » Re: I/O and db_file_multiblock_read_count
- » Re: I/O and db_file_multiblock_read_count
- » Re: I/O and db_file_multiblock_read_count
- » Re: I/O and db_file_multiblock_read_count
- » RE: I/O and db_file_multiblock_read_count
- » RE: I/O and db_file_multiblock_read_count
- » RE: I/O and db_file_multiblock_read_count
- » Re: I/O and db_file_multiblock_read_count
- » Re: I/O and db_file_multiblock_read_count
- » RE: I/O and db_file_multiblock_read_count
- » Re: I/O and db_file_multiblock_read_count
- » RE: I/O and db_file_multiblock_read_count
- » RE: I/O and db_file_multiblock_read_count
- » Re: I/O and db_file_multiblock_read_count
- » RE: I/O and db_file_multiblock_read_count
- » RE: I/O and db_file_multiblock_read_count
- » RE: I/O and db_file_multiblock_read_count
- » Re: I/O and db_file_multiblock_read_count
- » RE: I/O and db_file_multiblock_read_count
- » RE: I/O and db_file_multiblock_read_count
- » RE: I/O and db_file_multiblock_read_count
- » RE: I/O and db_file_multiblock_read_count
- » Re: I/O and db_file_multiblock_read_count
- » RE: I/O and db_file_multiblock_read_count
- » RE: I/O and db_file_multiblock_read_count
- » RE: I/O and db_file_multiblock_read_count
- » RE: I/O and db_file_multiblock_read_count
- » RE: I/O and db_file_multiblock_read_count
- » RE: I/O and db_file_multiblock_read_count
- » RE: I/O and db_file_multiblock_read_count
- » RE: I/O and db_file_multiblock_read_count
- » RE: I/O and db_file_multiblock_read_count
- » RE: I/O and db_file_multiblock_read_count
- » RE: I/O and db_file_multiblock_read_count
- » RE: I/O and db_file_multiblock_read_count
- » RE: I/O and db_file_multiblock_read_count
- RE: I/O and db_file_multiblock_read_count
- From: Keith Moore