object

 

select owner, object_name, object_type, to_char(logical_reads ,'99,999,999,999') logical_reads from ( select * from ( select /*+ rule */ OBJ# , logical_READS_DELTA logical_reads from dba_hist_SEG_STAT a where snap_id = 42266 and a.INSTANCE_NUMBER =userenv('INSTANCE') and logical_reads_delta > 0 order by 2 desc ) where rownum < 6 ) , dba_objects where obj# = object_id order by logical_reads desc