| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_gmail.com> wrote:Received on Fri Sep 09 2005 - 15:34:27 CDT
> 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
 |
 |