SELECT TABLE_NAME,TOTAL_PHYS_IO
FROM ( SELECT OWNER||'.'||OBJECT_NAME AS TABLE_NAME,
SUM(VALUE) AS TOTAL_PHYS_IO
FROM V$SEGMENT_STATISTICS
WHERE OWNER!='SYS' AND OBJECT_TYPE='TABLE'
AND STATISTIC_NAME IN ('physical reads','physical reads direct',
'physical writes','physical writes direct')
GROUP BY OWNER||'.'||OBJECT_NAME
ORDER BY TOTAL_PHYS_IO DESC
WHERE ROWNUM <=10;