there are always 9 sessions in active status which are used to lock SYS.RGROUP$

最新推荐文章于 2022-06-23 11:42:16 发布

转载最新推荐文章于 2022-06-23 11:42:16 发布 · 148 阅读

文章标签：

本文探讨了Oracle 9.2.0.6版本下大量物化视图(MV)在一分钟间隔内刷新的情况。系统中约有40-50个MV，在刷新过程中会锁定SYS.RGROUP$表，并在提交前释放锁。文中还提到了如何通过金属链文档监控MV刷新进度。

    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]