【DB笔试面试632】在Oracle中，如何锁住统计信息？

EXEC DBMS_STATS.LOCK_TABLE_STATS();  --表
EXEC DBMS_STATS.LOCK_PARTITION_STATS(); --分区表
EXEC DBMS_STATS.LOCK_SCHEMA_STATS(); --锁定用户统计信息
EXEC DBMS_STATS.UNLOCK_SCHEMA_STATS();--解锁用户统计信息

ERROR at line 1: 
ORA-20005: object statistics are locked (stattype = ALL) 
ORA-06512: at "SYS.DBMS_STATS", line 20337 
ORA-06512: at "SYS.DBMS_STATS", line 20360 
ORA-06512: at line 1 

SELECT D.OWNER,
       D.INDEX_NAME,
       D.TABLE_OWNER,
       D.TABLE_NAME,
       D.PARTITION_NAME,
       D.SUBPARTITION_NAME,
       D.OBJECT_TYPE
  FROM DBA_IND_STATISTICS D
 WHERE STATTYPE_LOCKED = 'ALL' 
UNION ALL
SELECT '',
       '',
       D.OWNER,
       D.TABLE_NAME,
       D.PARTITION_NAME,
       D.SUBPARTITION_NAME,
       D.OBJECT_TYPE
  FROM DBA_TAB_STATISTICS D
 WHERE STATTYPE_LOCKED = 'ALL' ;