为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。 【DM版本】: 【操作系统】: 【CPU】: 【问题描述】*:SYSSTATS 表里记录了表的统计信息,但是关联到DBA_TABLES时,DBA_TABLES的LAST_ANALYZED字段都为null,请问哪个字段才是 表的最后收集时间?
select A.ID as “对象ID”,B.OBJECT_NAME as “对象名”, A.COLID as “列ID”, A.T_FLAG as “对象标记”,LAST_GATHERED as “最后收集时间” from SYSSTATS A, DBA_OBJECTS B where A.ID=B.OBJECT_ID and B.OBJECT_NAME=‘xx’;
select A.ID as “对象ID”,B.OBJECT_NAME as “对象名”, A.COLID as “列ID”, A.T_FLAG as “对象标记”,LAST_GATHERED as “最后收集时间” from SYSSTATS A, DBA_OBJECTS B
where A.ID=B.OBJECT_ID and B.OBJECT_NAME=‘xx’;