RE: sequential read on full-table scan?

From: Martic Zoran <zoran_martic_at_yahoo.com>
Date: Wed, 25 May 2005 01:23:44 -0700 (PDT)
Message-ID: <20050525082344.17198.qmail@web52602.mail.yahoo.com>

Cary,

Thank you a lot.
I could not cover all test cases yesterday so easy because of no time and non-easy ways to trace parallel slave processes.
So I asked you/oracle-l list.

I just wanted to get more info about the direct path read associating with the parallel slaves from the master.
What is on the net is very scattered and in some cases
wrong. Also, very hard to find out anything about it except usual copied sentences from Oracle docs.

But it looks my old knowledge about it did not change.
So all blocks are going always to the PGA regardless of the cache.

Regards,
Zoran

• Cary Millsap <Cary.Millsap_at_hotsos.com> wrote:
  > I suspected that saying "never" might get me into
  > trouble. :)
  >
  > I think that 2 is false for direct path read,
  > because I believe that direct
  > path reads are not buffer cache managed. I should
  > have said, more precisely,
  > "Oracle will never PIO a block /into the buffer
  > cache/ that's already in the
  > buffer cache."
  >
  >
  > Cary Millsap
  > Hotsos Enterprises, Ltd.
  > http://www.hotsos.com
  > * Nullius in verba *
  

  ---

Do you Yahoo!?
Yahoo! Small Business - Try our new Resources site http://smallbusiness.yahoo.com/resources/

--
http://www.freelists.org/webpage/oracle-l

Received on Wed May 25 2005 - 04:28:33 CDT