Rollback error situation

From: <fsiegel_at_my-deja.com>
Date: Mon, 16 Oct 2000 15:32:32 GMT
Message-ID: <8sf72h$ie5$1@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. Received on Mon Oct 16 2000 - 10:32:32 CDT