About Shrink Rollback Seg

[ligang]

I found some rollback seg is increasing to 30MB ,
It's too big for my DB . So I set optimize size as
4M( next extend is 2M) and shrink it .
But after that , The size seems no change .

Why?

[sambavan]

[url]http://www.dbasupport.com/forums/showthread.php?threadid=7605[/url]

[url]http://www.dbasupport.com/forums/showthread.php?threadid=7879[/url]

[url]http://www.dbasupport.com/forums/showthread.php?threadid=6489[/url]

Hope these would help you,

Sam