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?
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?
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 Thu Apr 25 2002 - 17:12:53 CDT