there are always 9 sessions in active status which are used to lock SYS.RGROUP$
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博客 ” ，链接：https://blog.itpub.net/14730395/viewspace-680262/ ，如需转载，请注明出处，否则将追究法律责任。
