Re: performance issue after upgrade to

From: helter skelter <>
Date: Fri, 26 Aug 2011 19:59:42 +0200
Message-ID: <j38mv2$ot4$>

> Does changing compatible back fix it?
> May have nothing to do with anything, but you might want to rule out
> the mview bug After Mview Logs Creation, See A Lot Of 'Dfs Lock
> Handle' Waits On Dml. [ID 845886.1]
> jg
> --
> is bogus.

I've changed optimizer compatible back to - no results. I've also tried:

-drop and recreated mview log
-drop mview log
-rebuild indexes on destination table (bitmap and btree) results.

After 200k (from 2,6M) inserts to mview log it has more then 7GB of active UNDO! and it's growing linear.

HS Received on Fri Aug 26 2011 - 12:59:42 CDT

Original text of this message