Re: Reduce the size of undo and Index tbs?

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 <chiragdba@xxxxxxxxx> 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

Other related posts: