From oracle-l-bounce@freelists.org Fri Sep 9 14:20:44 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j89JKiOL029967 for ; Fri, 9 Sep 2005 14:20:44 -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 j89JKhIP029956 for ; Fri, 9 Sep 2005 14:20:43 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F03321E9C9C; Fri, 9 Sep 2005 14:20:35 -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 27614-05; Fri, 9 Sep 2005 14:20:35 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6AFBB1E96AA; Fri, 9 Sep 2005 14:20:35 -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:in-reply-to:mime-version:content-type:references; b=If/HRGGnVsS9trcSOYxMZO+2d1mqesSAtGilMGkQ4q5N+/3exWHNZMm4Bh8xtbLhV80S3OjrwLttHWafqE/zNK3tM+rHEukH2qLUheCFJB+Oqz3Eb6LNfO5qPz0jPKkZVC8s0cz9ZTOURc02CV+cAZd90BGtfUtZF/2PsIHkC2M= Message-ID: <1a362960050909121826ea899e@mail.gmail.com> Date: Fri, 9 Sep 2005 15:18:44 -0400 From: Chirag DBA To: Oracle-L Freelists , askdba@freelists.org Subject: Re: Reduce the size of undo and Index tbs? In-Reply-To: <1a362960050909120822f201f2@mail.gmail.com> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_6452_8477157.1126293524033" References: <1a362960050909120822f201f2@mail.gmail.com> X-archive-position: 25244 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-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.7 required=5.0 tests=AWL,BAYES_00,HTML_60_70, HTML_MESSAGE autolearn=no version=2.63 ------=_Part_6452_8477157.1126293524033 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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, =20 > My index tablespace and undo tablespace are of almost 5 gbs and DB is=20 > 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 > ------=_Part_6452_8477157.1126293524033 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
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         &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;  2  110074737
redo size      =             &nb= sp;            =             &nb= sp;            =          2 4.1850E+10
redo buffe= r allocation retries         &= nbsp;           &nbs= p;            &= nbsp;         2   &n= bsp; 203714
redo wastage          = ;            &n= bsp;            = ;            &n= bsp;            = ;  2  873540792
redo writer latching time   &nb= sp;            =             &nb= sp;            =         2     &= nbsp; 3772
redo writes        &n= bsp;            = ;            &n= bsp;            = ;            &n= bsp;    2    4959357
redo blocks written        &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;        2   86148255
r= edo write time          &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;           2  = ;  4891582
redo log space requests     &nb= sp;            =             &nb= sp;            =         2     &= nbsp; 1738
redo log space wait time        = ;            &n= bsp;            = ;            &n= bsp;    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.<= /div>
 
Anyone can gimme some idea?
 
Chirag

------=_Part_6452_8477157.1126293524033-- -- http://www.freelists.org/webpage/oracle-l