Shulou(Shulou.com)06/01 Report--

If hang lives in drop mv, you can enable 10046 to track to see where the operation is stuck. And the scene I encountered this time is stuck in delete sys.mvref$_change_stats. If the amount of data in this table reaches more than one million, it is likely to have performance problems and can be cleaned up. (execute statement: delete from sys.mvref$_change_stats where refresh_id=:B2 and mv_obj#=:B1) solution: truncate table mvref$_stats; truncate table mvref$_run_stats; truncate table mvref$change_stats; truncatea table mvref$_stmt_stats; exec dbms_mview_stats.set_system_default ('COLLECTION_LEVEL','NONE')

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.