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