Re: Rollback error situation

In article <8sf72h$ie5$1_at_nnrp1.deja.com>,   fsiegel_at_my-deja.com wrote:
> Job-A crashed because it cannot extend the rollback tablespace.
> Job-A was restarted and came down again with same reason.
>
> The applications people are absolutely certain that no other jobs were
> running and that the data amounts did not increase. This procedure
 has
> been running without fault for 1 year. When I did a manual shrink of
> the rollback segment, restarted the job, the job worked fine - no
> rollback problems!!
>
> Shrinks to Optimal are not happening automatically according to
> v$rollstat (# of shrinks remains constant before and after the job
> runs). There are many wraps and extends. Can anyone estimate what's
> going on here?
>
> Much Thanks,
> Frank S.
>

Looks like rollback segments are not planned carefully. Check if sum of optimal sizes of them is less than 70% of rollback tablespace (50% is better). Check if initial and next parameters are the same for all of the rollback segments (this will exclude fragmentation). By the way, shrink happens when segment is reused, not after transaction finished. So you have to allow for several rollback segments to be much bigger than optimal.

> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Oct 16 2000 - 17:08:35 CDT