From oracle-l-bounce@freelists.org Sun Apr 18 02:41:26 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i3I7fPj12755 for ; Sun, 18 Apr 2004 02:41:25 -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 i3I7fP612749 for ; Sun, 18 Apr 2004 02:41:25 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6072E72CA48; Sun, 18 Apr 2004 02:35:12 -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 21883-80; Sun, 18 Apr 2004 02:35:12 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 901B972CAAC; Sun, 18 Apr 2004 02:35:11 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Sun, 18 Apr 2004 02:34:00 -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 DFFE572C9A0 for ; Sun, 18 Apr 2004 02:33:59 -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 21834-60 for ; Sun, 18 Apr 2004 02:33:59 -0500 (EST) Received: from mail32.messagelabs.com (mail32.messagelabs.com [62.173.108.211]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 1022F72C8C5 for ; Sun, 18 Apr 2004 02:33:59 -0500 (EST) X-VirusChecked: Checked X-Env-Sender: Peter.Hitchman@thomson.com X-Msg-Ref: server-3.tower-32.messagelabs.com!1082274302!8981561 X-StarScan-Version: 5.2.10; banners=.,-,- X-Originating-IP: [62.200.87.120] Received: (qmail 15797 invoked from network); 18 Apr 2004 07:45:02 -0000 Received: from unknown (HELO mimesweeper1.derwent.co.uk) (62.200.87.120) by server-3.tower-32.messagelabs.com with SMTP; 18 Apr 2004 07:45:02 -0000 Received: from der-lon-msg-01.derwent.co.uk (unverified [10.228.5.119]) by mimesweeper1.derwent.co.uk (Content Technologies SMTPRS 4.3.12) with ESMTP id for ; Sun, 18 Apr 2004 08:46:11 +0100 Received: by mx0.derwent.co.uk with Internet Mail Service (5.5.2655.55) id <270723AD>; Sun, 18 Apr 2004 08:46:17 +0100 Message-ID: <8D697B8FCEBB3744B3A1E4AE15E8331E02DA83@der-lon-msg-03.derwent.co.uk> From: "Hitchman, Peter" To: "'oracle-l@freelists.org'" Subject: RE: Question on diff block sizes in DB Date: Sun, 18 Apr 2004 08:42:56 +0100 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2655.55) Content-type: text/plain X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 3292 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Peter.Hitchman@thomson.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Hi, Thanks for the update. I'll try to remember this if I ever get to work on Oracle 9i or higher. Pete -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Mladen Gogala Sent: 18 April 2004 08:08 To: oracle-l@freelists.org Subject: Re: Question on diff block sizes in DB Indexes were cached normally, with all other database objects. The tables in question were 20+GB in size (all Bloomberg data about north american stock exchanges, so called NAMR_EQUITY OUT and PX files, for more then 2 years) and the 16KB buffer pool of 80MB was used for full table scan. All other indexes, both bit-mapped and B*Tree were 8k and were properly cached. That way I reaped the benefits of the faster full table scan for the huge NAMR tables and I didn't interfere much with the rest of the objects. This 16k buffer pool was, in essence, a recycle buffer pool with a different blocksize, to facilitate faster full table scans. Indexes were unaffected, and that was the idea. It would be great to use compressed tables, because it would really give the big range scans a boost, but it would prevent me from adding columns and that would be bad, because our beloved mayor of the New York City sometimes adds new columns to the files. ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ ---------------------------------------------------------------- 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 -----------------------------------------------------------------