[askdba] Re: Reduce the size of undo and Index tbs?

  • From: Chirag DBA <chiragdba@xxxxxxxxx>
  • To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>, askdba@xxxxxxxxxxxxx
  • Date: Fri, 9 Sep 2005 15:18:44 -0400

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
>

Other related posts: