Re: Materialized View+complete refresh

  • From: Martin Berger <martin.a.berger@xxxxxxxxx>
  • To: mhdmehraj@xxxxxxxxx
  • Date: Fri, 22 May 2009 14:19:05 +0200


have you checked/created a histogram of the wait events the refresh creates? Where is most of the time spent? (There are several methods v $sesstat, ash, statspack, event10046, ... ) Then it might be easier to target this part of the refresh, instead of just guessing arount.

just an idea,

Hi ,
i have a materialized view , Only Complete referesh is possible on
that view since it contains lot of subquerys ,
In order to complete refresh it takes 20 minutes to do that,
So i need to reduce the refreshing time,

Plz help me out to solve this issue ...

Mohammed Mehraj Hussain.

Other related posts: