Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Rollback error situation
You can also write a job to motor v$rollstat and v$transaction and schedule to run it evry minute or so, this way you'll get an idea what's happenning to your rbs.
Gocha
<fsiegel_at_my-deja.com> wrote in message news:8sf72h$ie5$1_at_nnrp1.deja.com...
> 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.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.