From oracle-l-bounce@freelists.org Thu Sep 9 15:49:25 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i89KnNv32611 for ; Thu, 9 Sep 2004 15:49:23 -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 i89KnNI32606 for ; Thu, 9 Sep 2004 15:49:23 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9163472DBBE; Thu, 9 Sep 2004 15:50:58 -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 23794-03; Thu, 9 Sep 2004 15:50:58 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DE79272DBC9; Thu, 9 Sep 2004 15:50:57 -0500 (EST) From: "Steve Adams" To: , "''Oracle-L (E-mail)'" Subject: RE: Initrans Date: Fri, 10 Sep 2004 06:53:39 +1000 Message-ID: <003a01c496af$15476460$ae8735cb@ixora.com.au> MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit In-Reply-To: X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-archive-position: 9340 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: steve.adams@ixora.com.au Precedence: normal Reply-To: steve.adams@ixora.com.au X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Hi Hamid, No, don't set INITRANS to a non-default value unless you need to do so to avoid ITL waits. ITL waits are counted in V$SEGSTAT. The ITL can grow dynamically and preallocating extra slots just wastes space. Instead, ensure that you never set PCTFREE to zero, except on truly read-only tables. Only set FREELISTS on tables that get enough concurrent inserts to cause dynamic ITL growth. Take a few block dumps, and use the highest ITL size seen, raised to the next prime. There is very little downside here, only a few more block below the HWM, so you don't have to be too careful. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ - For DBAs @ http://www.christianity.net.au/ - For all -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Hamid Alavi Sent: Friday, 10 September 2004 1:49 AM To: 'Oracle-L (E-mail) Subject: Initrans List, I have heared the best number for Initras is the number of CPU but what about the Freelists is there any standard for this parameter too. Any idea for any standards for these two parameters? Number of CPU or average number of Transaction or what? Thanks, Hamid Alavi -- To unsubscribe - mailto:oracle-l-request@freelists.org&subject=unsubscribe To search the archives - http://www.freelists.org/archives/oracle-l/