segments with high physical read - Oracle Database Script.
SET pagesize 200 setlinesize 120 col segment_name format a20 col OWNER format a10
SELECT segment_name,
object_type,
total_physical_reads
FROM
(SELECT OWNER||'.'||object_name AS segment_name,
object_type,
value AS total_physical_reads
FROM v$segment_statistics
WHERE statistic_name IN ('physical reads')
ORDER BY total_physical_reads DESC)
WHERE rownum <=10;