From oracle-l-bounce@freelists.org Mon Mar 29 04:58:39 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2TAwcE32036 for ; Mon, 29 Mar 2004 04:58:38 -0600 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 i2TAwbo32028 for ; Mon, 29 Mar 2004 04:58:37 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 12F036342FC; Mon, 29 Mar 2004 05:55:26 -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 15535-64; Mon, 29 Mar 2004 05:55:25 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 46E6563430C; Mon, 29 Mar 2004 05:55:25 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 29 Mar 2004 05:54:18 -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 3FAE263428F for ; Mon, 29 Mar 2004 05:54:18 -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 15655-08 for ; Mon, 29 Mar 2004 05:54:18 -0500 (EST) Received: from ha-smtp0.tiscali.nl (ha-smtp0.tiscali.nl [195.241.76.186]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E34C563428C for ; Mon, 29 Mar 2004 05:54:17 -0500 (EST) Received: from LEXLAPTOP (82-168-217-228-bbxl.xdsl.tiscali.nl [82.168.217.228]) by ha-smtp0.tiscali.nl (Postfix) with SMTP id C9534490207 for ; Mon, 29 Mar 2004 13:02:12 +0200 (CEST) From: "Lex de Haan" To: Subject: RE: optimal storage parameters for heavy inserts tables Date: Mon, 29 Mar 2004 13:02:10 +0200 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.6604 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Importance: Normal In-Reply-To: X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 1959 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: lex.de.haan@naturaljoin.nl Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Hi Niall, I agree -- it never hurts to use a prime number for any assignment algorithm based on a modulo function. on the other hand, the difference between choosing primes vs. non-primes only becomes apparent if the input numbers (process IDs) show some pattern... cheers, Lex. -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Niall Litchfield Sent: maandag 29 maart 2004 11:45 To: oracle-l@freelists.org Subject: RE: optimal storage parameters for heavy inserts tables I believe that the logic would be that chosing a prime number for number of freelists makes sense in that sessions should then be spread evenly across the available freelists. Niall Litchfield Oracle DBA Audit Commission +44 117 975 7805 ********************************************************************** This email contains information intended for the addressee only. It may be confidential and may be the subject of legal and/or professional privilege. Any dissemination, distribution, copyright or use of this communication without prior permission of the sender is strictly prohibited. ********************************************************************** ---------------------------------------------------------------- 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 -----------------------------------------------------------------