物化视图调优

物化视图跑的慢
DROP 物化视图日志；
DROP 物化视图；
CRAETE 物化视图日志；
CREATE 物化视图；
是不是有碎片


select * from v$session_longops ab where ab.SID='5005' and ab.SERIAL#='7425';
select * from dba_mview_logs




select bytes/1024/1024/1024 from dba_segments
where segment_name='MLOG$_POL_BEN'


select * from MLOG$_POL_BEN;
drop  MATERIALIZED VIEW LOG on  POL_BEN;         
drop MATERIALIZED VIEW POL_BEN_ACTUARY;