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/