Optimal Rollback Segment Size Question

I know that in Oracle 7 rollback segments can shrink back to a pre-defined optimal size, but I need to know how to make this work.

For example, I have a rollback segment that currently as 13 extents allocated using approx. 2.8M of space. If I set the optimal size to 200K, how do I force Oracle to shrink this rollback segment.

I went into SQL*Plus and did a 'set transaction use rollback segment r01' and then issued a delete from a table to delete 28 rows and rolled back that transaction. When I went back into monitor rollback it still showed that segment rc01 was using 2.8M. How do I make it shrink???

Do I need to issue a transaction that is larger that the optimal size or even larger than the currently allocated size??

Any suggestions

Mike Campbell
mlcampb1_at_ingr.com Received on Wed Oct 19 1994 - 10:54:24 CET