how to lock statistics for the tables

一、查看表的statistics 的方法

select table_name,owner,stattype_locked from dba_tab_statistics where stattype_locked is not null; 

二、lock statistics for the table 方法

exec dbms_stats.lock_table_stats ('<schema>','<table>');

三、ulock statistics for the table 方法

exec dbms_stats.ulock_table_stats ('<schema>','<table>');

四、gather statistics on the table 

<pre name="code" class="sql">exec dbms_stats.gather_index_stats ('<schema>','<table>');