Unnamed
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