本文共 2436 字,大约阅读时间需要 8 分钟。
Event | Waits | Time(s) | Avg wait (ms) | % DB time | Wait Class |
---|---|---|---|---|---|
control file sequential read | 628,810 | 3,843 | 6 | 65.33 | System I/O |
DB CPU | 847 | 14.40 | |||
db file sequential read | 90,656 | 314 | 3 | 5.34 | User I/O |
log file sync | 2,572 | 297 | 116 | 5.06 | Commit |
Event | % Event | P1, P2 , P3 | % Activity | Parameter 1 | Parameter 2 | Parameter 3 |
---|---|---|---|---|---|---|
control file sequential read | 38.21 | "0","1","1" | 6.14 | file# | block# | blocks |
| | "0","17","1" | 3.41 | file# | block# | blocks |
| | "0","18","1" | 2.71 | file# | block# | blocks |
Elapsed Time (s) | Executions | per Exec (s) | %Total | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
1,789.17 | 30 | 59.64 | 30.42 | 0.74 | 8.18 | JDBC Thin Client | SELECT * FROM ( select '- Tabl... | |
1,745.27 | 35 | 49.86 | 29.67 | 0.92 | 5.01 | JDBC Thin Client | SELECT to_char(sum( NVL(a.byte... |
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23718752/viewspace-1804757/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/23718752/viewspace-1804757/