Hi Pando,

I think this problem can be compared with configuring a recycle buffer pool which is to small to cache the table which is asigned to it.

When performing a full table scan the table does not fit in the recycle pool and I/O is heavely increased.
While oracle builds the result set

HTH
tycho