{統計}統計情報をロック/強制上書き/アンロック

 

https://docs.oracle.com/cd/F19136_01/tgsql/controlling-the-use-of-optimizer-statistics.html#GUID-6D85C813-5FBF-4655-ACE5-1E50DB4F8E60

begin
dbms_stats.lock_table_stats('sh','tokei');
end;
/

select * from dba_tab_statistics where table_name = 'TOKEI';

 

 

begin
dbms_stats.gather_table_stats(
'sh',
'tokei');
end;
/

begin
dbms_stats.gather_table_stats(
'sh',
'tokei',
force =>true
);
end;
/

begin
dbms_stats.unlock_table_stats(
'sh',
'tokei'
);
end;
/

select * from dba_tab_statistics where table_name = 'TOKEI';