Re: Materialized View+complete refresh
From: Martin Berger <martin.a.berger_at_gmail.com>
Date: Fri, 22 May 2009 14:19:05 +0200
Message-Id: <474335E0-CEF8-45EF-9FB9-515F6D133525_at_gmail.com>
Hi,
Date: Fri, 22 May 2009 14:19:05 +0200
Message-Id: <474335E0-CEF8-45EF-9FB9-515F6D133525_at_gmail.com>
Hi,
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,
Martin
> 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 ...
>
> Regards,
> Mohammed Mehraj Hussain.
> Bangalore
> --
> http://www.freelists.org/webpage/oracle-l
-- http://www.freelists.org/webpage/oracle-lReceived on Fri May 22 2009 - 07:19:05 CDT
- application/pkcs7-signature attachment: smime.p7s