Return
-
Title
What is the DBO - Invalid Materialized View alarm? -
Description
Beginning with the 5.9.7.10 Oracle database cartridge, materialized views have been added as a new type of invalid object for Oracle agents. The Storage | invalid object dashboard includes the Materialized Views column in the table and chart.A new alarm has also been associated with the new object type. The “DBO - Invalid Materialized Views” alarm fires when invalid materialized views exist in a database schema. Materialized views in invalid state need to be compiled successfully before they are available to be queried against. In Oracle12C and higher versions this alarm can also be invoked at the PDB level. -
Resolution
Users can navigate to the storage | invalid object dashboard with alarm triggered time range by clicking the 'Alarm Time' link in alarm detail popup. Users can also navigate to storage | invalid object dashboard with current time range by clicking the 'Current Time' link in alarm detail popup. Changing the threshold for the number of materialized views in the alarm configuration is reflected in the alarm firing condition.
The video provides information on the DBO - Invalid Materialized Views alarm
-
Defect ID
FOM-77