Re: Reduce the size of undo and Index tbs?
- From: Jared Still <jkstill@xxxxxxxxx>
- To: chiragdba@xxxxxxxxx
- Date: Fri, 9 Sep 2005 13:32:25 -0700
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