Description of the illustration dbr_rep_wait_time_dist.gif
The Wait Time Distribution subsection of a sample report is shown in this graphic. This subsection contains two tables.
The first table, named Time Period (1), contains three columns: Event (1), Wait Time (1), and Event Count (1). The values of each row in this table are as follows:
-
log file switch (checkpoint incomplete) Configuration, 239.88801, 12
-
direct path write temp User I/O, 10, 2924
-
log buffer space Configuration, 10, 6
The second table, named Time Period (2), contains three columns: Event (2), Wait Time (2), and Event Count (2). The values of each row in this table are as follows:
-
direct path read user I/O, 590, 185443
-
log file switch (checkpoint incomplete) Configuration, 114.33483, 20
-
direct path read temp User I/O, 80, 132686
-
free buffer waits Configuration, 70, 435
-
direct path write temp User I/O, 50, 73
-
db file sequential read User I/O, 50, 11617
-
log file switch completion Configuration, 30. 44
-
log buffer space Configuration, 30, 34
-
latch: row cache objects Concurrency, 10, 28
-
undo segment extension Configuration, 10, 4
End of image description.