2 Replies Latest reply: Jan 10, 2013 3:39 AM by Pinela RSS

    How to check refreshing materialized views

    Sabrina711
      Hi, experts

      I'm right now doing the db upgrade for EBS R12.(11.1.07->11.2.03)
      When I do the pre-upgrade tool(utlu112i_5.sql), the warning result is like this:

      WARNING: --> There are materialized view refreshes in progress.
      *.... Ensure all materialized view refreshes are complete prior to upgrade.*

      I tried to select the V$Transaction ,but now rows showed.
      The application has stopped for 2 days,so I think there should not be any MV refreshing.

      Could you tell me can I now do the upgrade?
      If not what should I do to fasten the refreshing and know when the mv is ready to upgrade?

      SELECT DISTINCT(TRUNC(last_refresh))
      FROM dba_snapshot_refresh_times;

      (TRUNC(LAST_REFRES
      ------------------
      27-NOV-02
      26-SEP-08
      30-MAR-09
      30-JUN-05
      29-AUG-08
      24-FEB-08
      22-FEB-08
      18-FEB-08
      25-FEB-08
      03-NOV-04
      01-DEC-12

      (TRUNC(LAST_REFRES
      ------------------
      23-FEB-08
      09-JUL-08
      28-AUG-08

      14 rows selected.


      Thanks.

      Edited by: 975328 on 2013-1-8 下午6:45

      Edited by: 975328 on 2013-1-8 下午6:48