Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Unix filesystem: use buffered IO or direct IO?
On 25 Apr 2002 15:12:53 -0700, yong321_at_yahoo.com (Yong Huang) wrote:
>Isn't sequential read sequential, like in the case of index scan (full
>or range)? Isn't reading TEMP direct path read, bypassing Oracle
>buffer cache?
I believe that i/o with TEMP is probably version/platform dependent.
My personal expereince is that I have seen it used with TEMP, and the
the only times I have ever seen multiple blocks retrieved with the
sequential event was with datafiles belonging to the TEMP tablespace.
>
>Full table scans are usually db file scattered read, scattered at the
>OS level.
>
>Yong Huang
>yong321_at_yahoo.com
>
>Michael Brown <mlbrown_at_apps-dba.net> wrote in message news:<qq4bcusa3bos2nr0ichgl6sm5uher4i5u3_at_4ax.com>...
>> db file sequential read is either random single block reads or
>> transfers from the TEMP tablespace during a sort. The TEMP tablespace
>> I/O might benefit from buffering, but odds are the random single block
>> reads won't see any benefit from system buffers assuming that your
Received on Fri Apr 26 2002 - 12:47:39 CDT