sys@ORA102>analyze table test.jobs compute statistics;
analyze table test.jobs compute statistics
*
ERROR at line 1:
ORA-38029: object statistics are locked
要运行一个dbms包才能解开
sys@ORA102>begin
2 dbms_stats.unlock_table_stats('TEST','JOBS');
3 end;
4 /
PL/SQL procedure successfully completed.
sys@ORA102>analyze table test.jobs compute statistics;
Table analyzed.
锁统计信息时可以类似这样
BEGIN
DBMS_STATS.DELETE_TABLE_STATS('OE','ORDERS');
DBMS_STATS.LOCK_TABLE_STATS('OE','ORDERS');
END;
/
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/119941/viewspace-705340/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/119941/viewspace-705340/