ROLLBACK SEGMENT Tuning

Hi I noticed few of rollback segment in one of Database are having few waits.Is it necessary to create rollback segment with new size? Can u please some one send some infor on rollback segment tunning? Thx -Seema _ Add photos

RE: Rollback Segment tuning

Hi all,=0D =0D How to find out the smallest (minimal) transaction size from Dictionary vie= w or base tables =0D I try to set my OPTIMAL rollback segment base on smallest transaction size = to prevent ora-1555. since shrinking rollback segments may cause ora-1555.= =0D =0D =0D Thanks =0D =0D

RE: Rollback Segment tuning

Thanks man, I mean the minimum optimal size base on the maximum transaction size, So the HWM is the answer ? Sinardy -Original Message- Sent: 03 June 2002 16:53 To: Multiple recipients of list ORACLE-L Hi all,=0D =0D How to find out the smallest (minimal) transaction size from

RE: Rollback Segment tuning

Hi Stephane, I run the script and I have OPTIMAL = 5 * ceil(max(v$rollstat.aveactive) / 4 / sys.ts$.blocksize)* sys.ts$.blocksize / 1024 the result is 0 K for my optimal. : ) regards, Sinardy -Original Message- Sent: 03 June 2002 16:53 To: Multiple recipients of list ORACLE-L

RE: RE: Rollback Segment tuning

Thanks man,=0D =0D I mean the minimum optimal size base on the maximum transaction size, So th= e HWM is the answer ?=0D =0D =0D Sinardy=0D =0D Depends. If activity was 'normal', yes (if HWM is about the same for all RS, you can be fairly confident with the value). If somebody has run a big

RE: RE: Rollback Segment tuning

Hi Stephane,=0D =0D I run the script and I have =0D =0D OPTIMAL =3D 5 * ceil(max(v$rollstat.aveactive) / 4 / sys.ts$.blocksize)* sy= s.ts$.blocksize / 1024 =0D =0D the result is 0 K for my optimal. : )=0D =0D regards,=0D Sinardy=0D Probably not enough significant activity. It tries to set

Re: Rollback Segment tuning

I find that not setting OPTIMAL seems to be optimal. Jared Sinardy Xing [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/02/2002 09:53 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Rollback Segment

Rollback Segment tuning

Hi all, How to find out the smallest (minimal) transaction size from Dictionary view or base tables I try to set my OPTIMAL rollback segment base on smallest transaction size to prevent ora-1555. since shrinking rollback segments may cause ora-1555. Thanks Sinardy -- Please see the