Database DataWarehousing (MOSC)

MOSC Banner

fast refresh of materialized view running slow

edited Jan 9, 2012 7:16PM in Database DataWarehousing (MOSC) 1 commentAnswered
we do a refresh of the materialized view every day, and it usually took 15 minutes. However, today it took 3 hours.I done some research and saw this as a data issue.  If the number of data changed since yesterday is huge, it would be like a completed refresh.

To see if this is true for our case, is there a way to query how many rows was refreshed yesterday?

thanks

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