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';