From oracle-l-bounce@freelists.org Wed Apr 28 09:07:30 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i3SE73M10307 for ; Wed, 28 Apr 2004 09:07:13 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i3SE6g610199 for ; Wed, 28 Apr 2004 09:07:03 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 15D5972CC0F; Wed, 28 Apr 2004 08:58:24 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 13399-63; Wed, 28 Apr 2004 08:58:23 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0C88372CD1E; Wed, 28 Apr 2004 08:58:23 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 28 Apr 2004 08:57:07 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E12DF72CE41 for ; Wed, 28 Apr 2004 08:57:06 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 13399-40 for ; Wed, 28 Apr 2004 08:57:06 -0500 (EST) Received: from qescan1.qgraph.com (QESCAN2.qgraph.com [206.158.124.8]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 28C0372CE2B for ; Wed, 28 Apr 2004 08:57:06 -0500 (EST) Received: by sxsmtp1.qgraph.com with Internet Mail Service (5.5.2657.72) id ; Wed, 28 Apr 2004 09:09:47 -0500 Message-ID: From: "Jesse, Rich" To: "ORACLE-L (E-mail)" Subject: Needing to brush up on my internals -- FTS and DB buffer cache Date: Wed, 28 Apr 2004 09:09:58 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-type: text/plain; charset=iso-8859-1 X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 3941 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Rich.Jesse@quadtechworld.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org 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." It's been awhile since I took the Oracle7 DBA courses, but I have it stuck into my head that FTS data was plopped into the LRU end of the DB buffer cache's LRU list, instead of the MRU end. I gave up trying to look through my course material (my suggestion of an *INDEX* in the student guides apparently wasn't implemented) and MetaLink showed nothing. I couldn't find anything directly in the 8i docs, either, but a reference to the CACHE hint that says it causes FTSs to go to the MRU end of the buffer cache LRU list, but it doesn't say what happens by default and I didn't want to assume it was how I remembered it. So, is my memory just bad (it's not unusual) or what? Has this changed over versions? The article doesn't say what version of Oracle the author was referring to. TIA, Rich Rich Jesse System/Database Administrator rich.jesse@quadtechworld.com QuadTech, Sussex, WI USA ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@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 -----------------------------------------------------------------