oracle version: oracle 9.2.0.6
os version: linux as 3
In my system ,there are many materialized views.About 40-50.And,the interval time they refresh are almost 1 minite.
when I see the v$session ,there are always 7-9 active sessions.what they execute is that
SELECT R.REFGROUP
FROM SYS.RGROUP$ R
WHERE R.OWNER = :b1
AND R.NAME = :b2
AND R.INSTSITE = :b3
FOR UPDATE
from metalink,I see that when a materialized view refresh ,it will lock the sys.rgroup$ first ,and before they commit the refresh,the lock will release.
so,I think these active sessions will not be worried.
associate metalink document:
How to monitor the progress of a materialized view refresh (MVIEW) [ID 258021.1]
MATERIALIZED VIEW REFRESH: Locking, Performance, Monitoring [ID 258252.1]
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/14730395/viewspace-680262/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/14730395/viewspace-680262/
本文探讨了Oracle 9.2.0.6版本下大量物化视图(MV)在一分钟间隔内刷新的情况。系统中约有40-50个MV,在刷新过程中会锁定SYS.RGROUP$表,并在提交前释放锁。文中还提到了如何通过金属链文档监控MV刷新进度。
1187

被折叠的 条评论
为什么被折叠?



