完成开始
,2
,3,,dbms_stats.gather_table_stats (ownname =祝辞,GZ_SAFETY, tabname=祝辞MB_BSS_USER_LOCATION,, partname =祝辞PART_20170621);
,4,结束;
,5/开始
,
,dbms_stats.gather_table_stats (ownname =祝辞,GZ_SAFETY, tabname=祝辞MB_BSS_USER_LOCATION,, partname =祝辞PART_20170621);
结束;
ora - 20005: objectstatistics 断开连接;locked (=stattype 全部)
ora - 06512: at “SYS.DBMS_STATS line 24281年
ora - 06512: at “SYS.DBMS_STATS line 24332年
ora - 06512: at line 3
查看统计信息锁定情况:
select distincttable_name, stattype_locked 得到user_tab_statistics where table_name =癕B_BSS_USER_LOCATION”;
完成,execdbms_stats.gather_table_stats (ownname =祝辞,GZ_SAFETY, tabname=祝辞MB_BSS_USER_LOCATION,,力=祝辞真的),,/*强制收集*/PL/SQL procedure successfully 完成
,
完成;
完成;
完成,exec dbms_stats.unlock_table_stats (ownname=祝辞,‘GZ_SAFETY’, tabname=祝辞MB_BSS_USER_LOCATION);,/*解锁*/PL/SQL procedure successfully 完成
补充:解锁模式。
DBMS_STATS.UNLOCK_schema_STATS(用户);
