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/09/18 15:00:00','YYYY/MM/DD HH24:MI:SS') and to_date('2007/09/18 15: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) db file sequential read 9/18/2007 3:00:00 PM 40913 9/18/2007 3:00:00 PM 0 PX Deq: Signal ACK 9/18/2007 3:01:00 PM 99005 9/18/2007 3:01:00 PM 0 db file sequential read 9/18/2007 3:01:00 PM 20061 9/18/2007 3:02:00 PM 0 db file sequential read 9/18/2007 3:02:00 PM 13393 9/18/2007 3:03:00 PM 0 PX Deq Credit: send blkd 9/18/2007 3:04:00 PM 1410 9/18/2007 3:04:00 PM 0 db file sequential read 9/18/2007 3:05:00 PM 24973 PX Deq Credit: send blkd 9/18/2007 3:05:00 PM 3160 9/18/2007 3:05:00 PM 0 9/18/2007 3:06:00 PM 0 db file sequential read 9/18/2007 3:07:00 PM 43540 9/18/2007 3:07:00 PM 0 PX Deq Credit: send blkd 9/18/2007 3:07:00 PM 403 db file sequential read 9/18/2007 3:08:00 PM 0 9/18/2007 3:08:00 PM 0 9/18/2007 3:09:00 PM 0 db file sequential read 9/18/2007 3:09:00 PM 20625 9/18/2007 3:10:00 PM 0 db file sequential read 9/18/2007 3:10:00 PM 11870 null event 9/18/2007 3:10:00 PM 0 db file sequential read 9/18/2007 3:11:00 PM 38417 9/18/2007 3:11:00 PM 0 db file sequential read 9/18/2007 3:12:00 PM 38005 log file parallel write 9/18/2007 3:12:00 PM 85414 log file sync 9/18/2007 3:12:00 PM 193021 9/18/2007 3:12:00 PM 0 9/18/2007 3:13:00 PM 0 db file sequential read 9/18/2007 3:13:00 PM 18535 Log archive I/O 9/18/2007 3:14:00 PM 32896 db file sequential read 9/18/2007 3:14:00 PM 54266 log file sequential read 9/18/2007 3:14:00 PM 16767 9/18/2007 3:14:00 PM 0 PX Deq Credit: send blkd 9/18/2007 3:14:00 PM 62 9/18/2007 3:15:00 PM 0 db file sequential read 9/18/2007 3:15:00 PM 24356 9/18/2007 3:16:00 PM 0 PX Deq Credit: send blkd 9/18/2007 3:16:00 PM 1919682 db file sequential read 9/18/2007 3:16:00 PM 16063 9/18/2007 3:17:00 PM 0 9/18/2007 3:18:00 PM 0 db file sequential read 9/18/2007 3:18:00 PM 17596 PX Deq Credit: send blkd 9/18/2007 3:18:00 PM 680 db file sequential read 9/18/2007 3:19:00 PM 34648 9/18/2007 3:19:00 PM 0 PX Deq Credit: send blkd 9/18/2007 3:19:00 PM 0 db file sequential read 9/18/2007 3:20:00 PM 302734 PX Deq Credit: send blkd 9/18/2007 3:20:00 PM 0 9/18/2007 3:20:00 PM 0 db file sequential read 9/18/2007 3:21:00 PM 37250 9/18/2007 3:21:00 PM 0 Log archive I/O 9/18/2007 3:22:00 PM 63984 db file sequential read 9/18/2007 3:22:00 PM 12388 9/18/2007 3:22:00 PM 0 9/18/2007 3:23:00 PM 0 db file sequential read 9/18/2007 3:23:00 PM 60458 PX Deq Credit: send blkd 9/18/2007 3:23:00 PM 23437490 PX Deq Credit: send blkd 9/18/2007 3:24:00 PM 23437315 db file sequential read 9/18/2007 3:24:00 PM 53328 9/18/2007 3:24:00 PM 0 db file scattered read 9/18/2007 3:25:00 PM 5302 PX Deq Credit: send blkd 9/18/2007 3:25:00 PM 0 db file sequential read 9/18/2007 3:25:00 PM 86343 PX Deq Credit: send blkd 9/18/2007 3:26:00 PM 340 db file sequential read 9/18/2007 3:26:00 PM 750166 9/18/2007 3:26:00 PM 0 latch: row cache objects 9/18/2007 3:27:00 PM 0 cursor: pin S wait on X 9/18/2007 3:27:00 PM 75043 latch: library cache 9/18/2007 3:27:00 PM 0 9/18/2007 3:27:00 PM 0 db file sequential read 9/18/2007 3:27:00 PM 912238 PX Deq Credit: send blkd 9/18/2007 3:27:00 PM 54686035 latch free 9/18/2007 3:27:00 PM 3107155 latch: shared pool 9/18/2007 3:27:00 PM 1552575 9/18/2007 3:28:00 PM 0 latch: library cache 9/18/2007 3:28:00 PM 0 latch: shared pool 9/18/2007 3:28:00 PM 0 latch: row cache objects 9/18/2007 3:28:00 PM 0 row cache lock 9/18/2007 3:28:00 PM 5857801 PX Deq Credit: send blkd 9/18/2007 3:28:00 PM 82020320 cursor: pin S wait on X 9/18/2007 3:28:00 PM 75048 cursor: pin S wait on X 9/18/2007 3:29:00 PM 246593 latch: row cache objects 9/18/2007 3:29:00 PM 0 latch: library cache 9/18/2007 3:29:00 PM 0 PX Deq Credit: send blkd 9/18/2007 3:29:00 PM 82030105 latch: shared pool 9/18/2007 3:29:00 PM 0 row cache lock 9/18/2007 3:29:00 PM 11714826 9/18/2007 3:29:00 PM 0 latch: session allocation 9/18/2007 3:29:00 PM 0 row cache lock 9/18/2007 3:30:00 PM 11716765 latch: library cache 9/18/2007 3:30:00 PM 0 cursor: pin S wait on X 9/18/2007 3:30:00 PM 321668 PX Deq Credit: send blkd 9/18/2007 3:30:00 PM 82024274 latch: shared pool 9/18/2007 3:30:00 PM 0 9/18/2007 3:30:00 PM 0 latch: row cache objects 9/18/2007 3:30:00 PM 0 latch: session allocation 9/18/2007 3:30:00 PM 0 PX Deq Credit: send blkd 9/18/2007 3:31:00 PM 82023959 latch: library cache 9/18/2007 3:31:00 PM 0 row cache lock 9/18/2007 3:31:00 PM 11717729 latch: shared pool 9/18/2007 3:31:00 PM 0 latch: row cache objects 9/18/2007 3:31:00 PM 0 cursor: pin S wait on X 9/18/2007 3:31:00 PM 321655 latch: session allocation 9/18/2007 3:31:00 PM 0 9/18/2007 3:31:00 PM 0 cursor: pin S wait on X 9/18/2007 3:32:00 PM 965412 latch: library cache 9/18/2007 3:32:00 PM 0 PX Deq Credit: send blkd 9/18/2007 3:32:00 PM 41012340 9/18/2007 3:32:00 PM 0 latch: shared pool 9/18/2007 3:32:00 PM 0 row cache lock 9/18/2007 3:32:00 PM 2929435 latch free 9/18/2007 3:32:00 PM 882536 latch: row cache objects 9/18/2007 3:32:00 PM 0 PX Deq Credit: send blkd 9/18/2007 3:37:00 PM 41014747 9/18/2007 3:37:00 PM 0 db file sequential read 9/18/2007 3:37:00 PM 59091 cursor: pin S 9/18/2007 3:37:00 PM 678 library cache load lock 9/18/2007 3:37:00 PM 987688 kksfbc child completion 9/18/2007 3:37:00 PM 99816 cursor: pin S wait on X 9/18/2007 3:37:00 PM 67191 db file sequential read 9/18/2007 3:38:00 PM 11492 9/18/2007 3:38:00 PM 0 PX Deq Credit: send blkd 9/18/2007 3:38:00 PM 82022733 db file sequential read 9/18/2007 3:39:00 PM 41505 db file scattered read 9/18/2007 3:39:00 PM 44118 PX Deq Credit: send blkd 9/18/2007 3:39:00 PM 82030753 9/18/2007 3:39:00 PM 0 PX Deq Credit: send blkd 9/18/2007 3:40:00 PM 82020997 db file sequential read 9/18/2007 3:40:00 PM 10725 db file scattered read 9/18/2007 3:40:00 PM 14989 db file sequential read 9/18/2007 3:41:00 PM 66474 PX Deq Credit: send blkd 9/18/2007 3:41:00 PM 82023974 db file scattered read 9/18/2007 3:41:00 PM 4002 9/18/2007 3:41:00 PM 0 db file scattered read 9/18/2007 3:42:00 PM 20090 9/18/2007 3:42:00 PM 0 PX Deq Credit: send blkd 9/18/2007 3:42:00 PM 87883852 PX Deq Credit: send blkd 9/18/2007 3:43:00 PM 169908106 9/18/2007 3:43:00 PM 0 db file sequential read 9/18/2007 3:43:00 PM 11022 db file scattered read 9/18/2007 3:43:00 PM 11168 PX Deq Credit: send blkd 9/18/2007 3:44:00 PM 185531774 9/18/2007 3:44:00 PM 0 db file scattered read 9/18/2007 3:44:00 PM 1730 db file sequential read 9/18/2007 3:44:00 PM 22517 db file scattered read 9/18/2007 3:45:00 PM 24467 PX Deq Credit: send blkd 9/18/2007 3:45:00 PM 187488636 db file sequential read 9/18/2007 3:45:00 PM 16628 db file sequential read 9/18/2007 3:46:00 PM 9609 PX Deq Credit: send blkd 9/18/2007 3:46:00 PM 187484354 db file scattered read 9/18/2007 3:46:00 PM 4822 9/18/2007 3:46:00 PM 0 db file scattered read 9/18/2007 3:47:00 PM 928979 PX Deq Credit: send blkd 9/18/2007 3:47:00 PM 119130799 db file sequential read 9/18/2007 3:47:00 PM 889819 PX Deq Credit: send blkd 9/18/2007 3:48:00 PM 105465338 db file scattered read 9/18/2007 3:48:00 PM 5217 9/18/2007 3:48:00 PM 0 db file sequential read 9/18/2007 3:48:00 PM 25786 db file scattered read 9/18/2007 3:49:00 PM 16544 db file sequential read 9/18/2007 3:49:00 PM 6355 PX Deq Credit: send blkd 9/18/2007 3:49:00 PM 105457653 db file scattered read 9/18/2007 3:50:00 PM 4716 db file sequential read 9/18/2007 3:50:00 PM 33305 PX Deq Credit: send blkd 9/18/2007 3:50:00 PM 105467400 db file scattered read 9/18/2007 3:51:00 PM 149752 PX Deq Credit: send blkd 9/18/2007 3:51:00 PM 105458580 db file scattered read 9/18/2007 3:52:00 PM 4548 db file sequential read 9/18/2007 3:52:00 PM 6422 PX Deq Credit: send blkd 9/18/2007 3:52:00 PM 105454680 9/18/2007 3:52:00 PM 0 9/18/2007 3:53:00 PM 0 db file sequential read 9/18/2007 3:53:00 PM 35022 db file scattered read 9/18/2007 3:53:00 PM 22243 PX Deq Credit: send blkd 9/18/2007 3:53:00 PM 105463340 db file sequential read 9/18/2007 3:54:00 PM 75059 PX Deq Credit: send blkd 9/18/2007 3:54:00 PM 105464842 9/18/2007 3:54:00 PM 0 PX Deq Credit: send blkd 9/18/2007 3:55:00 PM 103520617 db file scattered read 9/18/2007 3:55:00 PM 35314 db file sequential read 9/18/2007 3:55:00 PM 18501 9/18/2007 3:55:00 PM 0 db file sequential read 9/18/2007 3:56:00 PM 19309 9/18/2007 3:56:00 PM 0 PX Deq Credit: send blkd 9/18/2007 3:56:00 PM 44926489 db file scattered read 9/18/2007 3:56:00 PM 22644 db file scattered read 9/18/2007 3:57:00 PM 18272 db file sequential read 9/18/2007 3:57:00 PM 7989 9/18/2007 3:57:00 PM 0 PX Deq Credit: send blkd 9/18/2007 3:57:00 PM 5868237 9/18/2007 3:58:00 PM 0 db file sequential read 9/18/2007 3:58:00 PM 38423 PX Deq Credit: send blkd 9/18/2007 3:58:00 PM 5752 db file scattered read 9/18/2007 3:58:00 PM 47959 db file sequential read 9/18/2007 3:59:00 PM 7730 db file scattered read 9/18/2007 3:59:00 PM 3804 9/18/2007 3:59:00 PM 0 PX Deq Credit: send blkd 9/18/2007 3:59:00 PM 11244