Query to find the table with most physica i/o

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 (‘physica l reads’,’physical reads direct’, ‘physical writes’,’physical writes direct’)
Group by owner ||’.’|| object_name
Order by total_phys_io desc ) where rownum <=10;
  • January 21, 2019 | 20 views
  • Comments