Re: Needing to brush up on my internals -- FTS and DB buffer cache

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Thu, 29 Apr 2004 00:24:36 +1000
Message-ID: <0ad601c42d2c$88a0d870$0100000a@FOOTE>

• Original Message ----- From: "Jesse, Rich" <Rich.Jesse_at_quadtechworld.com> To: "ORACLE-L (E-mail)" <oracle-l_at_freelists.org> Sent: Thursday, April 29, 2004 12:09 AM Subject: Needing to brush up on my internals -- FTS and DB buffer cache

While surfing Google for HP-UX questions, I ran across an Oracle guru page that says this:

"Remember, when Oracle performs a full-table scan, the database blocks are read directly into the program global area (PGA), bypassing the data buffer RAM." The article doesn't say what version of Oracle the author was referring to.

Hi Rich,

I've got a horrible feeling I know who the author is ....

Be afraid, be very afraid .

BTW, did the article mention "parallel" reads at all ? It's relevant.

Cheers

Richard

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Wed Apr 28 2004 - 09:21:05 CDT