SQL>ANALYZE TABLE TODAY.YGZHOU COMPUTE STATISTICS;

ORA-38029:object statistics are locked

要运行一个dbms包才能解开
SQL>begin
2 dbms_stats.unlock_table_stats('TODAY','YGZHOU');
3 end;
4 /

Table analyzed.

锁统计信息时可以类似这样
BEGIN
DBMS_STATS.DELETE_TABLE_STATS('OE','ORDERS');
DBMS_STATS.LOCK_TABLE_STATS('OE','ORDERS');
END;
/

SQL>BEGIN

DBMS_

ITPub博客

ORA-38029: object statistics are locked