Oracle * _ tab_statistics和带有 “列表陈旧” 的gather_schema_stat的陈旧对象结果之间的差异

begin  
    dbms_stats.flush_database_monitoring_info;  
    end;  
    /

select * from ALL_TAB_STATISTICS a where STALE_STATS = 'YES'  

declare  
lv_object_list dbms_stats.objecttab;  
p_filter_list dbms_stats.objecttab := dbms_stats.objecttab();  
begin  
dbms_stats.gather_schema_stats(ownname => 'XXXXX',  
                                     options => 'LIST STALE',  
                                     objlist => lv_object_list,  
                                     force => TRUE);  
FOR i IN 1 .. lv_object_list.count  
LOOP  
  dbms_output.put_line(lv_object_list(i).objName);  
END LOOP;                                       
end;  
/

create table t (
  x int primary key, y int
);

insert into t values (0, 0);
commit;
exec dbms_stats.gather_table_stats(user, 't');

insert into t
  select rownum, 1 from dual connect by level <= 100;
commit;

select table_name from user_TAB_STATISTICS a where STALE_STATS = 'YES' ; 

TABLE_NAME                    
------------------------------
PEOPLE

declare  
lv_object_list dbms_stats.objecttab;  
p_filter_list dbms_stats.objecttab := dbms_stats.objecttab();  
begin  
dbms_stats.gather_schema_stats(ownname => 'chris',  
                                     options => 'LIST STALE',  
                                     objlist => lv_object_list,  
                                     force => TRUE);  
FOR i IN 1 .. lv_object_list.count  
LOOP  
  dbms_output.put_line(lv_object_list(i).objName);  
END LOOP;                                       
end;  
/

PEOPLE
T

select table_name from user_TAB_STATISTICS a where STALE_STATS = 'YES' ; 

TABLE_NAME                    
------------------------------
PEOPLE
T