awr里边top sql 按次数排序，一般就是访问比较频繁的。

我觉得可以用这个sql试试：

select * 
    from (select rownum RN, T.* 
      from (select stat.OBJECT_NAME, stat.STATISTIC_NAME, stat.VALUE AcsValue, 
         sum(value) over(partition by stat.OBJECT_NAME) Total 
        from v$segment_statistics stat 
        where owner = <YOURSCHEMA> 
        and stat.OBJECT_TYPE = 'TABLE' 
        and stat.STATISTIC_NAME in 
         ('logical reads', 'pptimized physical reads', 
          'physical read requests', 'physical reads', 
          'physical reads direct', 'physical write requests', 
          'physical writes', 'physical writes direct') 
        order by sum(value) over(partition by stat.OBJECT_NAME) desc) T) TOrd 
where TOrd.RN < 50 https://blog.csdn.net/flighting_sky/article/details/8441308

根据时间段，生成awr，或者全局awr，查看segment statistics部分，有逻辑读、物理读、全表扫、写等top，根据你的需求去查