Untitled
public text v1 · immutableSQL 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