SQL Statement which produced this data: select event, trunc(sample_time, 'MI'), sum(time_waited) from dba_hist_active_sess_history where sample_time between to_date('2007/10/24 10:30:00','YYYY/MM/DD HH24:MI:SS') and to_date('2007/10/24 10:59:59','YYYY/MM/DD HH24:MI:SS') group by event, trunc(sample_time, 'MI') order by trunc(sample_time, 'MI') EVENT TRUNC(SAMPLE_TIME,'MI') SUM(TIME_WAITED) null 10/24/2007 10:30:00 AM 0 control file sequential read 10/24/2007 10:30:00 AM 347 db file sequential read 10/24/2007 10:30:00 AM 42245 null 10/24/2007 10:31:00 AM 0 db file sequential read 10/24/2007 10:31:00 AM 74716 null 10/24/2007 10:32:00 AM 0 db file sequential read 10/24/2007 10:32:00 AM 104305 log file sequential read 10/24/2007 10:32:00 AM 21059 SQL*Net more data to client 10/24/2007 10:32:00 AM 44148 SQL*Net more data from client 10/24/2007 10:32:00 AM 49 null 10/24/2007 10:33:00 AM 0 db file sequential read 10/24/2007 10:33:00 AM 20872 db file sequential read 10/24/2007 10:34:00 AM 298615 log file sync 10/24/2007 10:34:00 AM 1054 null 10/24/2007 10:34:00 AM 0 log file parallel write 10/24/2007 10:34:00 AM 1036 null 10/24/2007 10:35:00 AM 0 db file sequential read 10/24/2007 10:35:00 AM 86646 null 10/24/2007 10:36:00 AM 0 log file sequential read 10/24/2007 10:36:00 AM 201074 log file parallel write 10/24/2007 10:36:00 AM 10410 db file sequential read 10/24/2007 10:36:00 AM 474776 log file sync 10/24/2007 10:36:00 AM 10538 log file sync 10/24/2007 10:37:00 AM 2232 db file sequential read 10/24/2007 10:37:00 AM 255315 Log archive I/O 10/24/2007 10:37:00 AM 60907 null 10/24/2007 10:37:00 AM 0 log file parallel write 10/24/2007 10:37:00 AM 2208 log file sync 10/24/2007 10:38:00 AM 2905 db file sequential read 10/24/2007 10:38:00 AM 164156 log file parallel write 10/24/2007 10:38:00 AM 2214 null 10/24/2007 10:38:00 AM 0 log file parallel write 10/24/2007 10:39:00 AM 10159 db file sequential read 10/24/2007 10:39:00 AM 66144 null 10/24/2007 10:39:00 AM 0 log file sequential read 10/24/2007 10:39:00 AM 12976 Log archive I/O 10/24/2007 10:39:00 AM 28093 log file sync 10/24/2007 10:39:00 AM 10282 log file sequential read 10/24/2007 10:40:00 AM 97862 log file sync 10/24/2007 10:40:00 AM 22551 Log archive I/O 10/24/2007 10:40:00 AM 48397 null 10/24/2007 10:40:00 AM 0 log file parallel write 10/24/2007 10:40:00 AM 22484 db file sequential read 10/24/2007 10:40:00 AM 87763 log file sync 10/24/2007 10:41:00 AM 8088 db file sequential read 10/24/2007 10:41:00 AM 436237 null 10/24/2007 10:41:00 AM 0 log file parallel write 10/24/2007 10:41:00 AM 7871 latch: row cache objects 10/24/2007 10:42:00 AM 0 log file parallel write 10/24/2007 10:42:00 AM 1243 Log archive I/O 10/24/2007 10:42:00 AM 116448 latch: library cache 10/24/2007 10:42:00 AM 0 latch: shared pool 10/24/2007 10:42:00 AM 0 null 10/24/2007 10:42:00 AM 0 log file sync 10/24/2007 10:42:00 AM 1289 cursor: pin S wait on X 10/24/2007 10:42:00 AM 75048 latch free 10/24/2007 10:42:00 AM 0 db file sequential read 10/24/2007 10:42:00 AM 108351 cursor: pin S wait on X 10/24/2007 10:43:00 AM 193876 null 10/24/2007 10:43:00 AM 0 latch free 10/24/2007 10:43:00 AM 0 latch: row cache objects 10/24/2007 10:43:00 AM 0 latch: library cache 10/24/2007 10:43:00 AM 0 latch: shared pool 10/24/2007 10:43:00 AM 0 db file sequential read 10/24/2007 10:43:00 AM 55551 latch free 10/24/2007 10:44:00 AM 0 db file sequential read 10/24/2007 10:44:00 AM 22659 latch: library cache 10/24/2007 10:44:00 AM 0 null 10/24/2007 10:44:00 AM 0 cursor: pin S wait on X 10/24/2007 10:44:00 AM 64357 latch: row cache objects 10/24/2007 10:44:00 AM 0 latch: shared pool 10/24/2007 10:44:00 AM 0 rdbms ipc reply 10/24/2007 10:53:00 AM 0 log file parallel write 10/24/2007 10:53:00 AM 3768 log file sync 10/24/2007 10:53:00 AM 0 db file sequential read 10/24/2007 10:53:00 AM 83717 os thread startup 10/24/2007 10:53:00 AM 55594 read by other session 10/24/2007 10:53:00 AM 4526 null 10/24/2007 10:53:00 AM 0 db file sequential read 10/24/2007 10:54:00 AM 70844 null 10/24/2007 10:54:00 AM 0 null 10/24/2007 10:55:00 AM 0 db file sequential read 10/24/2007 10:55:00 AM 115890 null 10/24/2007 10:56:00 AM 0 db file sequential read 10/24/2007 10:56:00 AM 142548 db file sequential read 10/24/2007 10:57:00 AM 64730 null 10/24/2007 10:57:00 AM 0 db file sequential read 10/24/2007 10:58:00 AM 76949 control file parallel write 10/24/2007 10:58:00 AM 7909 null 10/24/2007 10:58:00 AM 0 control file parallel write 10/24/2007 10:59:00 AM 6910 null 10/24/2007 10:59:00 AM 0 db file sequential read 10/24/2007 10:59:00 AM 28467