查看收集统计信息的时间间隔

查看收集统计信息的时间间隔

select owner,

      table_name,

      partition_name,

      subpartition_name,

      stats_update_time,

      stats_update_time - lag(stats_update_time, 1, null) over(partition by owner, table_name order by stats_update_time) interval

 from DBA_TAB_STATS_HISTORY

where owner = 'SCOTT'

  and table_name = 'TEST'

order by owner, table_name, stats_update_time desc;