Re: materialized view
Date: Fri, 4 Dec 2009 09:54:59 +0200
Looks like the usual case with complete refresh performing delete and insert. Check parameter atomic_refresh in dbms_mview procedure. It was discussed quite a lot of times also here for example http://www.freelists.org/post/oracle-l/Mview-refresh-is-much-slower-in-10g,3
2009/12/4 Kar <kp0773_at_gmail.com>:
> 10.2.0.4 - Solaris
> dropping and recreating a MV takes 10 minutes. but while doing a complete
> refresh it takes 8 hour. would appreciate any tips before I think of
> converting it to a fast refresh ..
> thanks in advance.