From oracle-l-bounce@freelists.org Sun Apr 18 00:45:27 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i3I5jR107921 for ; Sun, 18 Apr 2004 00:45:27 -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 i3I5jR607916 for ; Sun, 18 Apr 2004 00:45:27 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9AA7872C9F7; Sun, 18 Apr 2004 00:39:14 -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 15127-63; Sun, 18 Apr 2004 00:39:14 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C855772CA3B; Sun, 18 Apr 2004 00:39:13 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Sun, 18 Apr 2004 00:38:02 -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 7F9BF72C993 for ; Sun, 18 Apr 2004 00:38:01 -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 05973-87 for ; Sun, 18 Apr 2004 00:38:01 -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 8FD2872C982 for ; Sun, 18 Apr 2004 00:38:00 -0500 (EST) X-VirusChecked: Checked X-Env-Sender: Peter.Hitchman@thomson.com X-Msg-Ref: server-14.tower-32.messagelabs.com!1082267342!11368040 X-StarScan-Version: 5.2.10; banners=.,-,- X-Originating-IP: [62.200.87.120] Received: (qmail 19787 invoked from network); 18 Apr 2004 05:49:02 -0000 Received: from unknown (HELO mimesweeper1.derwent.co.uk) (62.200.87.120) by server-14.tower-32.messagelabs.com with SMTP; 18 Apr 2004 05:49: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 06:50:12 +0100 Received: by mx0.derwent.co.uk with Internet Mail Service (5.5.2655.55) id <27072N7Z>; Sun, 18 Apr 2004 06:50:17 +0100 Message-ID: <8D697B8FCEBB3744B3A1E4AE15E8331E02DA81@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 06:46:52 +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: 3290 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, Just picking out the point you made about indexes. What benefits have you observed by having indexes in a tablespace with a different block size from its table? Regards Pete -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Mladen Gogala Sent: 17 April 2004 23:37 To: oracle-l@freelists.org Subject: Re: Question on diff block sizes in DB The main thing that must be understood is that one can have a table in 16k tablespace and an index in 8k tablespace. -- Mladen Gogala Oracle DBA ---------------------------------------------------------------- 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 ----------------------------------------------------------------- ______________________________________________________________________ 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 -----------------------------------------------------------------