Database DataWarehousing (MOSC)

MOSC Banner

MView refresh issue

edited Oct 30, 2013 6:38PM in Database DataWarehousing (MOSC) 2 commentsAnswered
 We changed one of our views to a Materialized View in order to improve performance of the queries that hit the view.  However, since making this decision we have run into a number of issues with maintaining the data in the MV. 
There have been access issues in the lower environments, the production environment was refreshing the view on every Read, and now the only way to refresh the view in prod is to delete and recreate the MV causing every function or procedure that uses it to become invalid in the process.
 
The big issue is surrounding the refresh method for the MV.  The data in the tables that the view reads are updated only during releases and primarily when we are implementing new clients.  They are not updated by users through the application.  When they are updated during a release, we will have user validation work that is performed shortly after the update so we need the updates to be visible by the application shortly thereafter. 

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