本文共 4655 字,大约阅读时间需要 15 分钟。
Host Name | Platform | CPUs | Cores | Sockets | Memory (GB) |
---|---|---|---|---|---|
xxxxx | Linux x86 64-bit | 80 | 40 | 4 | 346.22 |
Snap Id | Snap Time | Sessions | Cursors/Session | |
---|---|---|---|---|
Begin Snap: | 33108 | 19-Feb-15 15:40:21 | 5147 | 5.4 |
End Snap: | 33109 | 19-Feb-15 15:50:22 | 5256 | 5.5 |
Elapsed: | 10.01 (mins) | |||
DB Time: | 533.14 (mins) |
Load Profile
Per Second | Per Transaction | Per Exec | Per Call | |
---|---|---|---|---|
DB Time(s): | 53.3 | 0.9 | 0.00 | 0.00 |
DB CPU(s): | 10.3 | 0.2 | 0.00 | 0.00 |
Redo size: | 2.2 MB | 37.4 KB | ||
Logical reads: | 10.3 GB | 179.3 MB | ||
Block changes: | 10,738.9 | 182.2 | ||
Physical reads: | 1.2 GB | 21.5 MB | ||
Physical writes: | 7.8 MB | 136.0 KB | ||
User calls: | 20,256.8 | 343.7 | ||
Parses: | 2,447.3 | 41.5 | ||
Hard parses: | 4.3 | 0.1 | ||
W/A MB processed: | 72.5 | 1.2 | ||
Logons: | 4.6 | 0.1 | ||
Executes: | 11,414.1 | 193.7 | ||
Rollbacks: | 0.6 | 0.0 | ||
Transactions: | 58.9 |
Top 5 Timed Foreground Events
Event | Waits | Time(s) | Avg wait (ms) | % DB time | Wait Class |
---|---|---|---|---|---|
db file sequential read | 13,019,569 | 15,375 | 1 | 48.06 | User I/O |
enq: TX - row lock contention | 403 | 7,779 | 19303 | 24.32 | Application |
DB CPU | 6,185 | 19.34 | |||
direct path read | 425,941 | 1,882 | 4 | 5.88 | User I/O |
read by other session | 1,126,812 | 774 | 1 | 2.42 | User I/O |
Elapsed Time (s) | Executions | Elapsed Time per Exec (s) | %Total | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
01:39:59 | 1,344 | 4.46 | 18.75 | 0.33 | 0.00 | JDBC Thin Client | /* CL_ProcessController_update... | |
01:25:38 | 95 | 54.08 | 16.06 | 6.94 | 96.79 | bl1extract@ccbdbpr1 (TNS V1-V3) | SELECT /*+ leading (list payp... | |
2,612.67 | 206 | 12.68 | 8.17 | 8.55 | 94.69 | bl1extract@ccbdbpr1 (TNS V1-V3) | SELECT /*+ leading (cust rate ... | |
1,800.85 | 519 | 3.47 | 5.63 | 0.01 | 0.00 | JDBC Thin Client | /* AC_AcCloseUpdateAcControl_u... | |
1,554.22 | 13 | 119.56 | 4.86 | 17.15 | 86.22 | JDBC Thin Client | select /*+ leading (bpm_ai bpm... | |
1,476.63 | 13 | 113.59 | 4.62 | 30.53 | 66.68 | JDBC Thin Client | /* CL_ProcInstScanner_selectAv... | |
952.12 | 361,344 | 0.00 | 2.98 | 12.69 | 92.74 | bl1extract@ccbdbpr1 (TNS V1-V3) | /* */ SELECT CUSTOMER_ID, SUBS... | |
924.90 | 13 | 71.15 | 2.89 | 30.09 | 66.53 | JDBC Thin Client | /* CL_WaitScanner_selectWorkab... | |
600.66 | 0 | 1.88 | 8.85 | 94.53 | JDBC Thin Client | SELECT OK.BAN, OK.MSISDN, OK.P... | ||
565.49 | 0 | 1.77 | 4.19 | 97.80 | JDBC Thin Client | /* Formatted on 2012/04/26 16:... | ||
514.37 | 2,552,072 | 0.00 | 1.61 | 99.27 | 0.00 | getdate_int@ccbdbpr1 (TNS V1-V3) | select TO_CHAR(LOGICAL_DATE, '... |
Buffer Gets | Executions | Gets per Exec | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
1.2 TB | 2,552,072 | 486.9 KB | 19.12 | 514.37 | 99.27 | 0.00 | getdate_int@ccbdbpr1 (TNS V1-V3) | select TO_CHAR(LOGICAL_DATE, '... | |
705.8 GB | 25 | 28.2 GB | 11.39 | 105.95 | 72.71 | 27.95 | JDBC Thin Client | select bl1_run_request.run_mod... | |
234.0 GB | 13 | 18.0 GB | 3.78 | 1,476.63 | 30.53 | 66.68 | JDBC Thin Client | /* CL_ProcInstScanner_selectAv... | |
228.4 GB | 13 | 17.6 GB | 3.69 | 924.90 | 30.09 | 66.53 | JDBC Thin Client | /* CL_WaitScanner_selectWorkab... | |
190.4 GB | 335 | 582.0 MB | 3.07 | 192.38 | 99.90 | 0.00 | JDBC Thin Client | SELECT COUNT(1) FROM (/* null_... |
Executions | Rows Processed | Rows per Exec | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
2,552,072 | 2,551,077 | 1.00 | 514.37 | 99.27 | 0.00 | getdate_int@ccbdbpr1 (TNS V1-V3) | select TO_CHAR(LOGICAL_DATE, '... | |
445,868 | 445,865 | 1.00 | 14.05 | 90.20 | 0.20 | JDBC Thin Client | Select CSM_TRX_1SQ.NEXTVAL fro... | |
380,095 | 380,041 | 1.00 | 101.08 | 21.71 | 83.42 | java_q4p@ccbappr7 (TNS V1-V3) | SELECT ch_objects.obj_id, ch_o... |
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23718752/viewspace-1438776/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/23718752/viewspace-1438776/