Database Administration (MOSC)

MOSC Banner

Materialized View Fast Refresh

edited Sep 27, 2019 5:08AM in Database Administration (MOSC) 4 commentsAnswered

Hi,

Our ETL job that refresh materialized view is taking so much time for refresh. Below are detail of Materialized View.

1- Materialized view refresh by method complete refresh.

2- Materialized view script/sql contain select statement on multiple table in which few table has millions of records due to which FULL TABLE SCAN is used on these table.

3- UNION ALL is used.

4- DB Link is used to get data from Other Database.

To resolve this issue i want to choose FAST REFRESH OPTION but i am not sure whether we can use FAST refresh with above Complexity in Materialized View. Also To use FAST REFRESH we need to enable Materialized view log on master table , so in my case on which table  i have to enable Materialized view log. Please suggest.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center