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  /

SQL>ANALYZE TABLE TODAY.YGZHOU COMPUTE STATISTICS;

Table analyzed.

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

SQL>BEGIN

DBMS_