{統計}統計のリストア

 

https://docs.oracle.com/cd/F19136_01/tgsql/managing-historical-optimizer-statistics.html#GUID-D3050CB5-C0FA-4BD7-B7FF-88566437D461

begin
dbms_stats.restore_table_stats(
'sh',
'tokei',
as_of_timestamp =>to_timestamp('20241205 01:00:11','yyyymmdd hh24:mi:ss')
);
end;
/

select * from dba_tab_stats_history where table_name = 'TOKEI'
order by STATS_UPDATE_TIME;

select * from dba_tab_statistics where table_name = 'TOKEI';