官网链接:
https://docs.oracle.com/en/database/oracle/oracle-database/19/arpls/DBMS_STATS.html#GUID-C4AB1862-71AB-4F9F-9949-0D04B7CAE3F9

ERROR at line 1:
ORA-20000: Unable to analyze TABLE "ZABBIX"."TRENDS_UINT", insufficient
privileges or does not exist
ORA-06512: at "SYS.DBMS_STATS", line 40799
ORA-06512: at "SYS.DBMS_STATS", line 40072
ORA-06512: at "SYS.DBMS_STATS", line 40231
ORA-06512: at "SYS.DBMS_STATS", line 40780
ORA-06512: at line 1

exec dbms_stats.unlock_table_stats('ZBXORA','TRENDS_UINT');
exec dbms_stats.gather_table_stats('ZBXORA','TRENDS_UINT',estimate_percent=>0.01,method_opt=>'FOR ALL COLUMNS SIZE 1',granularity=>'ALL',cascade=>true,degree=>8);

版权声明：本文为博主原创文章，未经博主允许不得转载。

oracle