Re: materialized view
From: Gints Plivna <gints.plivna_at_gmail.com>
Date: Fri, 4 Dec 2009 09:54:59 +0200
Message-ID: <6e49b6d00912032354n4e2c0859haf1d5381497c3591_at_mail.gmail.com>
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
Date: Fri, 4 Dec 2009 09:54:59 +0200
Message-ID: <6e49b6d00912032354n4e2c0859haf1d5381497c3591_at_mail.gmail.com>
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
Gints Plivna
http://www.gplivna.eu
2009/12/4 Kar <kp0773_at_gmail.com>:
> All,
> 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.
> Kar
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Dec 04 2009 - 01:54:59 CST