How to check refreshing materialized views
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