From oracle-l-bounce@freelists.org Mon Oct 4 01:13:36 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i946DaR13032 for ; Mon, 4 Oct 2004 01:13:36 -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 i946DYI13026 for ; Mon, 4 Oct 2004 01:13:34 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0774572CA6F; Mon, 4 Oct 2004 01:19:39 -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 08744-28; Mon, 4 Oct 2004 01:19:38 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 697E372CA6E; Mon, 4 Oct 2004 01:19:38 -0500 (EST) Message-ID: <1be1d20041003231772ba0e93@mail.gmail.com> Date: Mon, 4 Oct 2004 11:47:59 +0530 From: Chirag DBA To: askdba@freelists.org, oracle-l@freelists.org Subject: Re: [askdba] Re: How to tune tables for inserts and Updates? Cc: oracle-dba-masters@yahoogroups.com, dba_gurus@yahoogroups.com In-Reply-To: Mime-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit References: <87E9F113CEF1D211A4C30090273018742BD4AD@ddbcinc.ddbc.local> <1be1d2004100121422fe3633e@mail.gmail.com> X-archive-position: 10623 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: ChiragDBA@gmail.com Precedence: normal Reply-To: ChiragDBA@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Hi, I have one question here. I have a database with 60 tables and out of that 19 are for transaction and others will be populated with the help of nightly pumps. there are 17 indexes which are PK and FK, n others are required to create as per the requirement like Creating an index on Foreign key n some on the basis of search criteria n all. I think it may go upto 30 indexes. Environment will be HP - UX 11i and 9iR2. I m expecting 5000 transaction so I think 7 transactions in 2 minutes. Can this lead to any Performance problem ? I m very confident but the concrns from the client made me think again. I think this is a very small DB compare to other Databases. I have a plan for Block level tuning at a time of DB creation like small block size, n pctfree, pctused, freelists and all are ok. Or else I may put it in MTS too. No Querry is too big as I have tried to each entity in a different table which has reduced my data redundancy n to merge the keys I have Transaction tables which are very few. can any one see any performance issue? - Chiku -- http://www.freelists.org/webpage/oracle-l