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

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 View statistics Lock status: select distinctable_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); /* forcibly collect */PL/SQL procedure successfully completed SQL> SQL> exec dbms_stats.unlock_table_stats (ownname=> 'GZ_SAFETY', tabname=>'MB_BSS_USER_LOCATION'); /* Unlock */PL/SQL procedure successfully completed Supplement: Unlock schema. DBMS_STATS.UNLOCK_schema_STATS(user);

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.