Re: What does thir error mean ?

Saqib Zulfiqar wrote:
>
> aak2_at_Ra.MsState.Edu (Atif Ahmad Khan) wrote:

<snip>

>
> I'm not a DBA but we had this problem with 7.0.16. When we used to
> fresh install ORACLE the optimum size of the rollback segments were
> not being set, Extents get allocated when insert, delete etc are
> performed, but they weren't being de-allocated after the commit has
> been made,
> What we did ,was we offlined the rollback segments, dropped them and
> recreated them with the optimum size specified, Now the size of the
> RBS is your transaction size dependent, you'll have to figure out what
> the initial, next , optimum size would be, Or you might want to
> increase the size of your Rollback segments. For details refer to
> ORACLE's DBA Guide Documentation.
>
> Hope this helps
>
> Saqib Zulfiqar
> Software Engineer
> CresSoft Products Ltd.

Is this the only way to deallocate rollback segs ? I'd love to hear of another option. Is there any ?

Ansgar

-- 
 Ansgar Seiter          	 Group Prof. Ch. Schlier      
 Department of Physics  	                             
 University of Freiburg 	 Phone:  +49 761 203-5730      
 Hermann-Herder-Str. 3  	 FAX:    +49 761 203-5873            
 D-79104 Freiburg i.Br  	 E-Mail: seiter_at_phya3.physik.uni-freiburg.de 
 Germany