RE: sequential read on full-table scan?

From: Martic Zoran <zoran_martic_at_yahoo.com>
Date: Tue, 24 May 2005 08:26:33 -0700 (PDT)
Message-ID: <20050524152634.26094.qmail@web52607.mail.yahoo.com>

Cary,

Is 2) true for the direct path read?

Regards,
Zoran

• Cary Millsap <Cary.Millsap_at_hotsos.com> wrote:
  > It's because:
  >
  > 1) A single-block read is never a 'db file scattered
  > read'.
  > 2) Oracle will never PIO a block that's already in
  > the buffer cache.
  >
  

  ---

Yahoo! Mail Mobile
Take Yahoo! Mail with you! Check email on your mobile phone. http://mobile.yahoo.com/learn/mail

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

Received on Tue May 24 2005 - 11:31:19 CDT