Re: [Q] Rollback segment deallocation

Sadly you are expecting Rollback segments to act like the documentation says they should. That is not the case (at least to version 7.1.4). Rollback segements will only shrink the next time they are accessed. Try after expanding the rollback segment , start another process and set transaction to use that rollback.   Do a simple 1 row update and exit. The rollback should shrink.  There is an Oracle technical bulliten that you can request that will discuss this in detail. This issue really only becomes a problem is you have your large rollback segment in the same tablespace as your small OLTP Rollbacks. Since the large rollback is only used for infrequent long running updates and querys there is a risk it will eat up all the space in the tablespace and not shrink. Now the small rollbacks segments have  no room to grow. I recomend putting your large rollback in it's  own tablespace.

paul

-- 
Paul Collins
DBA
DATASTORM Technologies