From oracle-l-bounce@freelists.org Sat Oct 2 04:30:17 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i929UHK19540 for ; Sat, 2 Oct 2004 04:30:17 -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 i929UHI19535 for ; Sat, 2 Oct 2004 04:30:17 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 34C7372C231; Sat, 2 Oct 2004 04:36:21 -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 08462-83; Sat, 2 Oct 2004 04:36:21 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9BBE072C0B1; Sat, 2 Oct 2004 04:36:20 -0500 (EST) Message-ID: <962cf44b041002023422e3711e@mail.gmail.com> Date: Sat, 2 Oct 2004 17:34:44 +0800 From: zhu chao To: chzhu@ebay.com Subject: Re: Increase FREEIST w/o drop objects--sorry for the previous garbage code Cc: sinardyxing@bkgcomsvc.com, oracle-l@freelists.org In-Reply-To: <51613FB99DC6E54FAA12ED6A22281B84101FF9@sha-exm-01.corp.ebay.com> Mime-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit References: <51613FB99DC6E54FAA12ED6A22281B84101FF9@sha-exm-01.corp.ebay.com> X-archive-position: 10596 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: zhuchao@gmail.com Precedence: normal Reply-To: zhuchao@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org hi, To increase the freelists on an object, you must be 8.1.6+. and to modify the freelist groups (at least 9i), you need to recreate the object. Some old rules get changed while oracle continue to change. By the way, one of our senior dba said, the freelists needs to be prime " Freelists needs to be a prime number. If you cannot use 23, use 17", I don't know why. Anyone have experience? Regards -- Regards Zhu Chao www.cnoug.org -- http://www.freelists.org/webpage/oracle-l