| Event | % Event | P1 Value, P2 Value, P3 Value | % Activity | Parameter 1 | Parameter 2 | Parameter 3 |
| enq: TX - row lock contention | 79.98 | "1415053318","17694721","8540" | 2.33 |
name|mode | usn<<16 | slot | sequence |
| | | "1415053318","10223645","7215" | 1.63 |
| | |
| | | "1415053318","11599907","10314" | 1.59 |
| | |
| gc buffer busy | 5.43 | "9","2250270","65537" | 0.92 |
file# | block# | id# |
| log file sync | 2.84 | "29","3624154874","0" | 0.00 |
buffer# | sync scn | NOT DEFINED |
| enq: TX - index contention | 2.29 | "1415053316","4128773","858744" | 0.16 |
name|mode | usn<<16 | slot | sequence |
| db file sequential read | 1.43 | "202","2","1" | 0.01 |
file# | block# | blocks |
| SQL Id | SQL Text |
| 7bd3r84urtm8u | select LASTSEQID from ParticIDKeeper for update |
| 7j4jahj2b0n0w | insert into SystemLog ( ResultDT , JobCD, ParticipantID, EpisodeID, ResultCD, ResulTX) values (:1, :2, :3, :4, :5, :6) |
| 9k6466qth49pj | insert into Episodes (ParticipantID, EpisodeID, instrumentCD, instrumentversion, projectcd, enrollmethodcd, EnrollDate, lmptype, etestdata, authcd, distcd, custcd, customercd, reportflag) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14) |
| cpw5amz5aa8hy | update Authorization set curcount = curcount+:"SYS_B_0" where authcd = :1 |
| db7qh8puap919 | insert into MessageQueue (msgid, msgtype, instrumentCD, episodeID, participantID, tailored, expirydt, senddt) values ( :1, :2, :3, :4, :5, :6, :7, :8) |
| Slot Time (Duration) | Slot Count | Event | Event Count | % Event |
| 11:00:14 (9.8 min) | 56 | log file sync | 18 | 0.06 |
| | | CPU + Wait for CPU | 11 | 0.04 |
| | | db file sequential read | 5 | 0.02 |
| 11:10:00 (10.0 min) | 320 | log file sync | 72 | 0.25 |
| | | CPU + Wait for CPU | 50 | 0.18 |
| | | db file sequential read | 37 | 0.13 |
| 11:20:00 (10.0 min) | 1,183 | enq: TX - row lock contention | 386 | 1.36 |
| | | log file sync | 196 | 0.69 |
| | | gc buffer busy | 107 | 0.38 |
| 11:30:00 (10.0 min) | 17,442 | enq: TX - row lock contention | 15,112 | 53.16 |
| | | gc buffer busy | 803 | 2.82 |
| | | enq: TX - index contention | 309 | 1.09 |
| 11:40:00 (10.0 min) | 6,330 | enq: TX - row lock contention | 5,412 | 19.04 |
| | | gc buffer busy | 293 | 1.03 |
| | | enq: TX - index contention | 161 | 0.57 |
| 11:50:00 (10.0 min) | 1,271 | enq: TX - row lock contention | 294 | 1.03 |
| | | gc buffer busy | 265 | 0.93 |
| | | log file sync | 117 | 0.41 |
| 12:00:00 (10.0 min) | 1,804 | enq: TX - row lock contention | 1,531 | 5.39 |
| | | log file sync | 49 | 0.17 |
| | | gc buffer busy | 43 | 0.15 |
| 12:10:00 (10.0 min) | 10 | CPU + Wait for CPU | 3 | 0.01 |
| | | control file sequential read | 3 | 0.01 |
| | | db file sequential read | 3 | 0.01 |
| 12:20:00 (10.0 min) | 3 | CPU + Wait for CPU | 1 | 0.00 |
| | | control file sequential read | 1 | 0.00 |
| | | db file sequential read | 1 | 0.00 |
| 12:30:00 (10.0 min) | 4 | CPU + Wait for CPU | 2 | 0.01 |
| | | control file sequential read | 2 | 0.01 |
| 12:40:00 (10.0 min) | 3 | Streams AQ: qmn coordinator waiting for slave to start | 1 | 0.00 |
| | | gc current block busy | 1 | 0.00 |
| | | row cache lock | 1 | 0.00 |
| 12:50:00 (10.0 min) | 1 | control file parallel write | 1 | 0.00 |