Re: why anlyze and rebuilding generate lot of redo ?

kw wrote:
>
> Hi all
>
> 8.1.7.0 on M$2000
>
> I use exec dbms_stats.gather_database_stats(); and then for every index
> in my app :
> "alter index XXX rebuild compute statistics;"
>
> After that there is 325 MB of new redo generated!!! (for both analyze
> and rebuilding indexes)
>
> Is there any way to avoid this huge redo generation ?
> Why ORACLE generate redo analyzing tables ?
>
> Thanks in advice
> Krzysztof Wlasiuk

Its probably the rebuild as others have noted.

If it actually is the analyze, maybe check your temporary tablespace defns. Analyze can do lots of sorts - if your temp tspace is "PERMANENT" then a lot more redo could be generated.

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."