SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Materialized view refresh is very slow in production

762575Mar 25 2010 — edited Apr 8 2010

Hi,

I am using Oracle 10.2.0.4.0 version and facing problem in Materialized view refresh in production.

There is a set of Materialized views (15 Mviews) are refreshed through refresh group in production every week or adhoc basis. And for refreshing it is taking 5hrs. I have refreshed the same set of Materialized views multiple times in development environment through refresh group but it got refreshed within 3min. The structure of materialized base tables, type of materialized view refresh, materialized definition and volume of base tables are same between development and production. The production disk space also larger than development. But I am not sure why in production the refresh is very slow compare to development. As this is very critical can some one help on this?

Thanks is advance.

- Gopinath.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 6 2010

Added on Mar 25 2010

5 comments

1,815 views