Home » Server Options » Replication » Is DBMS_MVIEW.REFRESH checks the status of mview?
Is DBMS_MVIEW.REFRESH checks the status of mview? [message #115413] Mon, 11 April 2005 07:57
Messages: 1
Registered: April 2005
Location: Seoul, Korea
Junior Member

Hi all,

Though the documents on 9i MVIEW insist that there's been tremendous improvements on making mview fast refresh-able on commit, I've failed to make my 4 ~ 6 table joining and aggregating query into fast refreshing mview.

To work around that, I've decided to make them, there are more than 20 mviews to make, refresh complete on demand and make use of dbms_mview.refresh/refresh_all/refresh_dependent.

Since the underlying tables change not so frequently, I wish those proc's be intelligent to check the status of every mv and only refresh stale ones.

So my question is that are they intelligent?

If not,

I may make use of 'all_mview_analysis' sys table which seems to offer me enough information to decide the status of mv.

Prompt response will be highly appreciated.

Noel Kim

From Korea Seoul
Previous Topic: Lock in MV while regenerating?
Next Topic: hard time with ORA-23308 in multimaster rep
Goto Forum:

Current Time: Fri Dec 03 05:51:40 CST 2021