Database DataWarehousing (MOSC)

MOSC Banner

Performance issues on replication with materialized views

edited Jul 4, 2014 5:00AM in Database DataWarehousing (MOSC) 1 commentAnswered

Hello,

We have several remote sites (Oracle Standard Edition 10.2.0.3.0), which are replicated to a central server (Oracle Standard Edition 12.1.0.1.0). Each remote site has the same schema (named as the city in which is located) and the central server replicates the entire schema for every site using read-only materialized views.

On the materialized view site, every hour many jobs are executed to refresh the groups of the MVs. Every group refreshes a different schema.

Problem is, only one refresh at a time can happen. All the other refreshes waits in line until the first is done, causing bottlenecks and performance issues.

Tagged:

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center