drop materialized view hung !!!

最新推荐文章于 2024-10-21 11:01:06 发布

转载最新推荐文章于 2024-10-21 11:01:06 发布 · 338 阅读

文章标签：

#数据库

当删除使用 db-link 引用远程对象的材料化视图时，Oracle 将检查视图的完整性。若 db-link 过期，则在此刻删除过程可能挂起，引发特定等待事件。

Cause: when you drop the materialized view ,then oracle will to check the integrity of the materilized view , if the mview is created referencing remote object by db-link. then Oracle will access the remote object.

Sometimes the db-link is expired, So when you drop mview at the moment, the process will hung and the wait events would be "single-task message" and "enq: TM-contention" .

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/350519/viewspace-1052711/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/350519/viewspace-1052711/