Database DataWarehousing (MOSC)

MOSC Banner

Materialized view issues

edited Jan 14, 2010 12:55AM in Database DataWarehousing (MOSC) 5 commentsAnswered
hi

I would like to post a query on Materialized view issues.

1. Across our 200 + stack of databases, number of tables are being replicated using materialized view tehnology. Off late as the table data  or the changes in the table grows these mviews are failing to get fast refreshed. Almost 80% of mviews where in the bulk changes happening at the source table are not able to get refreshed in time . The frequencies differ for each case.

I cannot stop bulk uploads neither delay the refresh interval.. We tried using streams and they really do have many bugs and putting that into production is a risk. Abruptly the replication stops and oracle says it is a bug.  We cannot afford this kind of problem in the replication.

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