From oracle-l-bounce@freelists.org Fri Sep 9 15:34:27 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j89KYR9X005525 for ; Fri, 9 Sep 2005 15:34:27 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j89KYOIP005514 for ; Fri, 9 Sep 2005 15:34:24 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B68821E9A04; Fri, 9 Sep 2005 15:34:16 -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 12673-03; Fri, 9 Sep 2005 15:34:16 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3FB791E99F5; Fri, 9 Sep 2005 15:34:16 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=gruyL9g63rA5TVFhAVHCJCDrK0CTKvaaEIzXQGju891di2A7oi4sbERBmUQai28Q8yjDD6xPnEeY7UXbAAvyq1Dc5ZpWhhTjiTCPeUgWkqCTL5RGO5zzEiWsGr9E9AQXeZUITzIaWC1ipAcnAIHxKfCIJTXwa479HdILrZyqIyo= Message-ID: Date: Fri, 9 Sep 2005 13:32:25 -0700 From: Jared Still To: chiragdba@gmail.com Subject: Re: Reduce the size of undo and Index tbs? Cc: Oracle-L Freelists In-Reply-To: <1a362960050909121826ea899e@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Content-Disposition: inline References: <1a362960050909120822f201f2@mail.gmail.com> <1a362960050909121826ea899e@mail.gmail.com> X-archive-position: 25249 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jkstill@gmail.com Precedence: normal Reply-To: jkstill@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-3.5 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=2.63 You first need to understand what REDO is. These 2 links will help: http://oraclesvca2.oracle.com/docs/cd/B19306_01/server.102/b14220/intro.htm#sthref35 http://oraclesvca2.oracle.com/docs/cd/B19306_01/server.102/b14220/memory.htm#sthref1310 You should also invest in a beginners book for DBA's. Oracle9i DBA 101 is highly recommended: http://www.amazon.com/exec/obidos/tg/detail/-/0072224746/qid=1126297761 You should also get a good book on Shell. My personal favorite is the venerable Kochan and Wood: http://www.amazon.com/exec/obidos/tg/detail/-/067248448X/qid=1126297863 Also, please do not cross-post to other lists. -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist 11+ years of trying to appear to know what I'm doing. On 9/9/05, Chirag DBA wrote: > My redo entries shows a very high number. > > redo size shows a 41gb. > > Our SGA size is 250 MB. Increasing that can help to reduce the redo? > > redo entries > 2 110074737 > redo size > 2 4.1850E+10 > redo buffer allocation retries > 2 203714 > redo wastage > 2 873540792 > redo writer latching time > 2 3772 > redo writes > 2 4959357 > redo blocks written > 2 86148255 > redo write time > 2 4891582 > redo log space requests > 2 1738 > redo log space wait time > 2 22266 > > - Chirag > > > Hi, > > > > > > > My index tablespace and undo tablespace are of almost 5 gbs and DB is only > of 35 GB. > > > > How can I reduce the size of this TBs with 3 -4 datafiles of 1- 2 GB. > > > > Anyone can gimme some idea? > > > > Chirag > > -- http://www.freelists.org/webpage/oracle-l