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;
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;