Re: Fast refresh takes eternity

From: News <Contact_404_at_hotmail.com>
Date: 28 Apr 2006 00:10:26 -0700
Message-ID: <1146208226.948329.120860@g10g2000cwb.googlegroups.com>

I run DBMS_ADVISOR.TUNE_MVIEW and got

QSM-03116: The materialized view is already optimal and cannot be tuned any
further

Since queries are joins only so Oracle considers them simple.

> Have you tried issuing a 10046 trace for the fast refersh on the
> refresh on both sides of the replication?

Yes. The processing is not blocked. internal refresh statements were running .. very heavy delete statement (dont know why oracle needs that since deletes never happen in data warehouse) followed by insert into .. select

May be materialized views are not good idea in this case ? refresh fast is not so fast in star queries generated automatically from star schemas !! There's nothing to tune! Received on Fri Apr 28 2006 - 02:10:26 CDT