在这篇简短的文章中,我想消除一个与在Oracle Exadata上运行的数据库的AWR分析有关的误解。近十年来,我一直面临一个问题:Exadata软件对生产力的贡献是什么?或使用新形成的单词:该数据库或该数据库的工作进行到什么程度?
, , AWR. , (DB CPU) .
Exadata AWR , Exadata Software. “cell” ( Exadata Storage ), “cell smart table scan”, “cell multiblock physical read” “cell single block physical read”.
Exadata- , Top10 Foreground Events by Total Wait Time ( Foreground Wait Events). AWR, Exadata- Top10 5%:
Event | Waits | Total Wait Time (sec) | Avg Wait | % DB time | Wait Class |
DB CPU |
| 115.2K |
| 70.4 |
|
SQL*Net more data from dblink | 670,196 | 5471.5 | 8.16ms | 3.3 | Network |
cell single block physical read | 5,661,452 | 3827.6 | 676.07us | 2.3 | User I/O |
Sync ASM rebalance | 4,350,012 | 3481.3 | 800.30us | 2.1 | Other |
cell multiblock physical read | 759,885 | 2252 | 2.96ms | 1.4 | User I/O |
direct path read | 374,368 | 1811.3 | 4.84ms | 1.1 | User I/O |
SQL*Net message from dblink | 7,983 | 1725 | 216.08ms | 1.1 | Network |
cell smart table scan | 1,007,520 | 1260.7 | 1.25ms | 0.8 | User I/O |
direct path read temp | 520,211 | 808.4 | 1.55ms | 0.5 | User I/O |
enq: TM - contention | 652 | 795.8 | 1220.55ms | 0.5 | Application |
AWR :
1. Exadata — 5 %, «» .
2. Exadata « + », . Exadata ( All Flash ), 5% - 15% — !
, , Exadata Software. Exadata -, « + ». «» — SQL-. Storage ( Exadata Storage Indexes, ) DB . , Exadata- .
Exadata? ? . , “cell smart table scan” Exadata Table Full Scan, - . AWR Exadata Exadata. «» AWR “Instance Activity Stats” ( ) .
, Exadata, . Exadata, , .
: , « »