Ora - 20005

SQL> begin 2  3   dbms_stats.gather_table_stats(ownname => 'GZ_SAFETY',tabname=>'MB_BSS_USER_LOCATION', partname =>'PART_20170621'); 4  end; 5  /begin  dbms_stats.gather_table_stats(ownname => 'GZ_SAFETY',tabname=>'MB_BSS_USER_LOCATION', partname =>'PART_20170621');end;ORA-20005: objectstatistics are locked (stattype = ALL)ORA-06512: at "SYS.DBMS_STATS",line 24281ORA-06512: at "SYS.DBMS_STATS",line 24332ORA-06512: at line 3查看统计信息锁定情况：select distincttable_name, stattype_locked from user_tab_statistics where table_name ='MB_BSS_USER_LOCATION';SQL> execdbms_stats.gather_table_stats(ownname => 'GZ_SAFETY',tabname=>'MB_BSS_USER_LOCATION', force=>TRUE); /*强制收集*/PL/SQL procedure successfully completed SQL>SQL>SQL> exec dbms_stats.unlock_table_stats(ownname=> 'GZ_SAFETY', tabname=>'MB_BSS_USER_LOCATION'); /*解锁*/PL/SQL procedure successfully completed补充：解锁schema。DBMS_STATS.UNLOCK_schema_STATS(user);