Database Administration (MOSC)

MOSC Banner

Status of MVIEW ( Is refreshing or working ok? )

How to see if a MVIEW stops working or updates or refreshing ?

In alert Logfile occur following meessages

MV OWNER.MVIEW_NAME was not refreshed successfully.

Number of MV refresh failures: 1.

1. Check, if status VALID ?

  select object_name, OBJECT_TYPE, status from user_objects where object_type='MATERIALIZED VIEW';

2. Check ALL_MVIEWS Column LAST_REFRESH_DATE a good starting point, but if you were checking with today's date, you'd have to include intervals as well.

   Column AFTER_FAST_REFRESH ?

    https://docs.oracle.com/en/database/oracle/oracle-database/12.2/refrn/ALL_MVIEWS.html#GUID-8B9432B5-6B66-411A-936E-590D9D7671E9

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