oracle查看物理IO前十的表 oracle查询表空间物理位置

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;