From oracle-l-bounce@freelists.org Fri Oct 1 06:33:27 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i91BXR218881 for ; Fri, 1 Oct 2004 06:33: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 i91BXRI18875 for ; Fri, 1 Oct 2004 06:33:27 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5A63D72C3A3; Fri, 1 Oct 2004 06:39:30 -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 29892-49; Fri, 1 Oct 2004 06:39:30 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B413672C39F; Fri, 1 Oct 2004 06:39:29 -0500 (EST) Message-ID: <9177895d04100104371aae0c44@mail.gmail.com> Date: Fri, 1 Oct 2004 07:37:52 -0400 From: rjamya To: chiragdba@gmail.com Subject: Re: How to tune tables for inserts and Updates? Cc: askdba@freelists.org, oracle-l@freelists.org In-Reply-To: <1be1d20040930231019bf736b@mail.gmail.com> Mime-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit References: <1be1d20040930231019bf736b@mail.gmail.com> X-archive-position: 10527 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: rjamya@gmail.com Precedence: normal Reply-To: rjamya@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org for imaginary problems, there are imaginary solutions. Let's say you spread your 'few' tables across 'few' tablespaces, and how exactly will that reduce your imaginary performance problem? Do you anticipate disk I/O issues? If so, spreading data out on more tablespaces with exactly same number of disk controllers wil resolve the issue? how so? 10000 per day is nothing, wait till it goes in production, monitor it. find out what the 'actual' problems are and then do something to implement the solution. Raj On Fri, 1 Oct 2004 11:40:26 +0530, Chirag DBA wrote: > Hi friends, > > I have a Database in which few tables are for Transaction. > > As the number of transactions will be more than 10000 per day, I need > to decide the tuning strategy for the tables having more hits. > > I m planning to put them ina different tablespace. > > Any other idea how I can do that. > > - Chirag Majmundar > Chirag@HP.Com -- http://www.freelists.org/webpage/oracle-l