Io by object

Oracle IO by Object

    CNT     AAS OBJN                     OTYPE
   ---- ------- ------------------------- ---------------
     79     .00 52949 ORDER_ITEMS         TABLE PARTITION
     97     .00 -1
    130     .00 53117 ORD_STATUS_IX       INDEX
    498     .01 53120 CUST_EMAIL_IX       INDEX
    512     .01 0
   1632     .03 53112 ITEM_ORDER_IX       INDEX

   select
          count(*) cnt,
          CURRENT_OBJ#||' '||o.object_name objn,
          o.object_type otype
   from v$active_session_history ash,
         all_objects o
   where ( event like 'db file s%' or event like 'direct%' )
      and o.object_id (+)= ash.CURRENT_OBJ#
      and sample_time > sysdate - &minutes/(60*24)
      and session_state='WAITING'
   group by 
          CURRENT_OBJ#, o.object_name ,
          o.object_type 
   Order by count(*)
   /