Re: rollback segment problem

I think it is a matter of timing.

Oracle WILL shrink a rollback segment back to the optimal size, but only when some future transaction wraps this particular rollback segment from its current extent into the next extent.

sureshna_at_my-dejanews.com wrote:

> Hi All,
>
> I am working on 7.3.3 on Sun OS 2.5.1.
>
> I have problem like this. In my database I have rollback tablespace has
> space of 250MB and I defined 10 rollback segments on that. When I run the
> script to cleanup the transaction tables as usual rollback segment space
> increases.
>
> I have setting for the rollback segment as inital 10k next 50k optimum 100k.
> As per Oracle manual if you set optimum setting after the transactions are
> commited, the rollback segment size will go back near 100k mark. but in my
> case it stays at for example 90MB. I have to personaly drop the rollback and
> recreate to reclaim the space.
>
> Can you anyone help me how to set the optimum parameter to work well
>
> thanks
>
> Suresh.N
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Fri Feb 12 1999 - 19:58:27 CST