ENDOCP1P > @physical

DATE                 PHYSICAL_READS_LAST_HOUR OBJECT_NAME
-------------------- ------------------------ --------------------
2013-11-03 Monday                        6054 D_1F000D5D80000910
2013-11-03 Monday                       26179 D_1F000D5D80000005
2013-11-03 Monday                       40332 D_1F000D5D80000901
2013-11-03 Monday                       46808 DM_SYSOBJECT_S_COMP2
2013-11-03 Monday                       64930 DM_RELATION_S
2013-11-03 Monday                       78228 NFL_CONTENT_R_COMP1
2013-11-03 Monday                       79647 DM_SYSOBJECT_S_COMP1
2013-11-03 Monday                      135421 DMR_CONTENT_S
2013-11-03 Monday                      165087 NFL_CONTENT_R
2013-11-03 Monday                      243480 DM_SYSOBJECT_R_COMP1
2013-11-03 Monday                      548052 D_1F000D5D8000010A
2013-11-03 Monday                     1475076 DM_SYSOBJECT_R_COMP2

ENDOCP1P > list
  1  select to_char(c.BEGIN_INTERVAL_TIME,'YYYY-MM-DD Day') "DATE",
  2  sum(b.PHYSICAL_READS_DELTA) PHYSICAL_READS_LAST_HOUR,
  3  a.object_name
  4  from dba_objects a,dba_hist_seg_stat b,sys.wRM$_SNAPSHOT c
  5  where b.SNAP_ID =(select max(SNAP_ID) from sys.wRM$_SNAPSHOT)
  6  and a.object_id=b.OBJ#
  7  and b.PHYSICAL_READS_DELTA>0
  8  and c.instance_number=(select instance_number from v$instance)
  9  and c.snap_id=b.snap_id
 10  group by to_char(c.BEGIN_INTERVAL_TIME,'YYYY-MM-DD Day'),a.object_name
 11* order by 2

ECSCDAP1P > @io605

INSTANCE  IO_PER_MINUTE STATISTIC_NAME          OBJECT_NAME
--------- ------------- ----------------------- -------------------------------------
CSCDAP1              12 physical reads          SYS.IDL_UB2$.
CSCDAP1              12 physical reads          SYS.IDL_CHAR$.
CSCDAP1              12 physical read requests  SYS.IDL_UB2$.
CSCDAP1              12 physical read requests  SYS.IDL_CHAR$.
CSCDAP1              84 physical reads          SYS.I_OBJAUTH2.
CSCDAP1              84 physical read requests  SYS.I_OBJAUTH2.
CSCDAP3             240 physical read requests  CDA_SHARED.SYS_LOB0000077712C00008$$.
CSCDAP3             252 physical reads direct   CDA_SHARED.SYS_LOB0000077712C00008$$.
CSCDAP3             252 physical reads          CDA_SHARED.SYS_LOB0000077712C00008$$.
CSCDAP3             276 physical reads          CDA_SHARED.SYS_LOB0000077712C00004$$.
CSCDAP3             276 physical read requests  CDA_SHARED.SYS_LOB0000077712C00004$$.
CSCDAP3             276 physical reads direct   CDA_SHARED.SYS_LOB0000077712C00004$$.
CSCDAP4             288 physical read requests  CDA_SHARED.SYS_LOB0000077712C00008$$.
CSCDAP1             288 physical reads direct   CDA_SHARED.SYS_LOB0000077712C00004$$.
CSCDAP1             288 physical reads          CDA_SHARED.SYS_LOB0000077712C00004$$.
CSCDAP1             288 physical read requests  CDA_SHARED.SYS_LOB0000077712C00004$$.
CSCDAP1             300 physical reads direct   CDA_SHARED.SYS_LOB0000077712C00008$$.
CSCDAP1             300 physical reads          CDA_SHARED.SYS_LOB0000077712C00008$$.
CSCDAP1             300 physical read requests  CDA_SHARED.SYS_LOB0000077712C00008$$.
CSCDAP4             312 physical reads direct   CDA_SHARED.SYS_LOB0000077712C00008$$.
CSCDAP4             312 physical reads          CDA_SHARED.SYS_LOB0000077712C00008$$.
CSCDAP4             360 physical reads direct   CDA_SHARED.SYS_LOB0000077712C00004$$.
CSCDAP4             360 physical reads          CDA_SHARED.SYS_LOB0000077712C00004$$.
CSCDAP4             360 physical read requests  CDA_SHARED.SYS_LOB0000077712C00004$$.
CSCDAP2             384 physical read requests  CDA_SHARED.SYS_LOB0000077712C00008$$.
CSCDAP2             396 physical reads          CDA_SHARED.SYS_LOB0000077712C00008$$.
CSCDAP2             396 physical reads direct   CDA_SHARED.SYS_LOB0000077712C00008$$.
CSCDAP2             480 physical read requests  CDA_SHARED.SYS_LOB0000077712C00004$$.
CSCDAP2             492 physical reads          CDA_SHARED.SYS_LOB0000077712C00004$$.
CSCDAP2             492 physical reads direct   CDA_SHARED.SYS_LOB0000077712C00004$$.
          -------------
sum                8184

io605.sql follows:
set termout off
set lines 160
break on report
col instance for a9
compute sum of io_per_minute break on report
drop table gv$segment_statistics1;
drop table gv$segment_statistics2;
column statistic_name format a23
create table gv$segment_statistics1 as select * from gv$segment_statistics 
where upper(statistic_name) like '%PHYSICAL%' and owner not like 'E%';
execute dbms_lock.sleep(5);
create table gv$segment_statistics2 as select * from gv$segment_statistics 
where upper(statistic_name) like '%PHYSICAL%' and owner not like 'E%';
set wrap off
set termout on
select i.instance_name instance,(b.value-a.value)*12 IO_PER_MINUTE,
a.statistic_name,
a.owner||'.'||a.object_name||'.'||a.subobject_name object_name
from gv$segment_statistics2 b,gv$segment_statistics1 a,gv$instance i
where a.statistic_name=b.statistic_name 
and a.inst_id=i.inst_id and b.inst_id=i.inst_id
and a.inst_id=b.inst_id and a.object_type=b.object_type
and a.owner||'.'||a.object_name||'.'||a.subobject_name=
b.owner||'.'||b.object_name||'.'||b.subobject_name
and upper(a.statistic_name) like '%PHYSICAL%'
and a.object_name not like 'GV$SEGMENT_STATISTICS%'
and b.value-a.value > 0
order by b.value-a.value;
set termout off
drop table gv$segment_statistics1 purge;
drop table gv$segment_statistics2 purge;
set termout on