Object and Tablespace I/O

The V$SEGMENT_STATISTICS view can be used to gather the statistics you need on access patterns of database segments. To find the database segments that incur the most I/O, use a query similar to the following: select owner,object_name,tablespace_name,sum(value) as total_io_operations from v$segment_statistics where statistic_name in ('physical reads','physical reads direct', 'physical writes','physical writes direct') group by owner,object_name,tablespace_name order by total_io_operations;