LOGICAL_READS_TOTAL                                   

 LOGICAL_READS_DELTA                                   

 BUFFER_BUSY_WAITS_TOTAL                         

 BUFFER_BUSY_WAITS_DELTA                         

 DB_BLOCK_CHANGES_TOTAL                          

 DB_BLOCK_CHANGES_DELTA                          

 PHYSICAL_READS_TOTAL                                 

 PHYSICAL_READS_DELTA                                 

 PHYSICAL_WRITES_TOTAL                               

 PHYSICAL_WRITES_DELTA                               

 PHYSICAL_READS_DIRECT_TOTAL                 

 PHYSICAL_READS_DIRECT_DELTA                 

 PHYSICAL_WRITES_DIRECT_TOTAL               

 PHYSICAL_WRITES_DIRECT_DELTA               

 TABLE_SCANS_TOTAL                                        

 TABLE_SCANS_DELTA

ttitle 'Physical Reads for GEN_PERSON table'

select

   to_char(begin_interval_time,'yy/mm/dd/hh24')     c1,

   physical_reads_total    c2

from

   dba_hist_seg_stat       s,

   dba_hist_seg_stat_obj   o,

   dba_hist_snapshot       sn

where

   o.owner = 'SCHEMA_07'

and

   s.obj# = o.obj#

and

   sn.snap_id = s.snap_id

and

   object_name = 'GEN_PERSON'

order by

   begin_interval_time;