Re: Can I tryst in "physical ... direct" figures?

As Terry points out, there could be a lot of sorting
going on. Your figure would not be unreasonable
(for example) in a data warehouse that was doing
lots of 'Create table as select'/'report table'.

To increase confidence - you could cross-check these
figures against the tablespace I/O figures. Direct writes
are usually multiblock writes. Direct reads are usually
multiblock reads - the tablespace (and file) stats will
give you a further indication of what proportion of
your reads and writes were direct.

It seams very strange to me that almost all writes and more then 1/2 of
reads is direct.
What do you think, can I trust on those figures? Can it be truth that all
writes are direct "bypassing the buffer cache, as written in Docs?