Re: How to clean up rollback tablespace?

Once a rollback segment is extended, the newly acquired extents won't be freed after commit, unless you set optimal of the rollback segment. You shouldn't deallocate these extents. If there is a new subsequent large transaction these extents will be again used. If you use the optimal clause the shrink the rollback segment, the rollback segment will need to be extended again, which is very costly. Please read up on Oracle concepts.

Hth,

Sybrand Bakker, Oracle DBA

Ming Luo <ming_at_sol1.lrsm.upenn.edu> schreef in berichtnieuws 8dl8ik$luq$1_at_netnews.upenn.edu...
> After "commit", there is still a lot of space were occupied in the
> rollback tablespace.
>
> My questions are:
>
> What data takes the space?
>
> How do I clean up it and reduce size of the rollback tablespace?
>
> Thanks in advance.
Received on Thu Apr 20 2000 - 00:00:00 CDT