I have created a materialized view in Oracle 12.1 database. The master table has materialized view log created, so that I can do a fast refresh.

I have executed the refresh using DBMS_MVIEW.REFRESH, but it is taking too much time.

I have verified network connectivity between two databases.

How can I troubleshoot the refresh process ?

migrated from serverfault.com May 17 at 18:02

This question came from our site for system and network administrators.

  • 1
    Check this link – Sam May 17 at 18:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.