Database Administration (MOSC)

MOSC Banner

Compiling a Materialized View while it is refreshing. Will this cause contention?

We are planning on setting up a job that will compile a materialized view every hour. The statement that we plan to execute will be as follows:

ALTER MATERIALIZED VIEW XXXXXXXXXX COMPILE;

Do you know if this could possibly cause issues if the compile ends up running at the same time as the MV refresh. The MV currently refreshes every 2 minutes.

The reason for wanting to the implement the compile job is because we have found that sometimes the MV stops refreshing. We suspect this happens whenever changes are made to objects that the MV depends on. Usually, the only way to resolve the problem is to manually recompile the MV. 

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