Re: Parallel Rollback Problem

> 4 rows with state = "RECOVERING". When I look at the sessions that are
> doing all the block changes in the database, they are the 4 PQ slaves and
> they tie back to SMON as the parent process. The problem is that they
> generate far more redo during this rollback than any transaction that
takes
> place on the database. It almost appears as if they are looping and
> spitting out redo. Eventually the archived log filesystem fills and the

What do you see from v$fast_start_transactions? Rolling back huge transactions do generate redo for each datablock change plus also for rollback segment blocks when their contents have been applied, so this might be normal..

Tanel. Received on Thu Aug 12 2004 - 14:09:53 CDT