Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Reduce the size of undo and Index tbs?
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
> 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-lReceived on Fri Sep 09 2005 - 14:20:44 CDT