Description:
The Oracle Materialized view was present until TIBCO BusinessWorks ProcessMonitor (BWPM) version 3.0.0.4. To know the status and latest refresh date, the database must be queried. The Materialized view was removed from the architecture in version BWPM 3.0.0.5 and onward.

How to check Oracle Materialized view status and other details in TIBCO BusinessWorks ProcessMonitor.

Product: TIBCO BusinessWorks™ ProcessMonitor Version:2.2.x, 3.0.0 to 3.0.0.4 OS: All Supported Operating Systems Database:Oracle --------------------

Query the configured database in TIBCO BusinessWorks ProcessMonitor (BWPM) to find the status of Materialized view by executing the following query.

1). Select  owner, object_name, object_type, status from dba_objects WHERE owner=’<BWPM DB Username>’ and OBJECT_NAME=’NJAMS_MV_STATISTICS’ and OBJECT_TYPE=’MATERIALIZED VIEW’

Sample result

    OWNER                OBJECT_NAME                    OBJECT_TYPE               STATUS
  ------------------             -------                                    ---------                             ---------
   BWPM300              NJAMS_MV_STATISTICS      MATERIALIZED VIEW       VALID


2). The latest refresh of Materialized view can be found by executing the following query.

SELECT owner, mview_name, last_refresh_date FROM dba_mviews WHERE owner = <BWPM DB Username>   AND mview_name = ’NJAMS_MV_STATISTICS’

Sample result

OWNER                          MVIEW_NAME                       LAST_REFR
------------------------------       -----------------------------                    ---------
BWPM300                        NJAMS_MV_STATISTICS            06-JUL-15