Service

resources per table v$segment_statistics

physical reads

select owner
,      object_name
,      subobject_name
,      tablespace_name
,      object_type
,      value physical_reads
,      round(100*(value/( sum(value) over () ) ) ) pct_total
,      sum(value) over () total
from v$segment_statistics
where statistic_name ='physical reads'
order by value desc

logical reads

select owner
,      object_name
,      subobject_name
,      tablespace_name
,      object_type
,      value logical_reads
,      round(100*(value/( sum(value) over () ) ) ) pct_total
,      sum(value) over () total
from v$segment_statistics
where statistic_name ='logical reads'
order by value desc

source : www.primos.nl