==============================================================
awr报告来自两个instance的rac,基于Solaris的11gR2,各具有32核心cpu(支持超线程)和128G内存:
----------------------------------------------------------------------------------------------------------------------------
DB Name DB Id Instance Inst num Startup Time Release RAC
EMSTA 433507400 emsta1 1 14-Aug-12 22:08 11.2.0.2.0 YES
Host Name Platform CPUs Cores Sockets Memory (GB)
emsta1 Solaris[tm] OE (64-bit) 64 32 8 128.00
==============================================================
awr采样区间为3小时(采样时间过长,不易定位问题),db time远小于elapsed * cpu核心数, 可以看出cpu负载相当轻, 这也可以从后面的"Host CPU"小节得到验证. 从session数大概可以推测db属于oltp类型.
----------------------------------------------------------------------------------------------------------------------------
Snap Id Snap Time Sessions Cursors/Session
Begin Snap: 6023 07-Sep-12 14:00:09 1788 2.8
End Snap: 6026 07-Sep-12 17:00:06 1793 2.9
Elapsed: 179.94 (mins)
DB Time: 79.25 (mins)
==============================================================
buffer cache 和 shared pool 大小, 前后一致, 说明没有出现内存波动, 即不存在内存不足的问题.
----------------------------------------------------------------------------------------------------------------------------
Cache Sizes
Begin End
Buffer Cache: 15,360M 15,360M Std Block Size: 8K
Shared Pool Size: 6,272M 6,272M Log Buffer: 111,456K
==============================================================
Load Profile 显示了数据库负载很轻
----------------------------------------------------------------------------------------------------------------------------
Load Profile
Per Second Per Transaction Per Exec Per Call
DB Time(s): 0.4 0.3 0.01 0.00
DB CPU(s): 0.4 0.2 0.01 0.00
Redo size: 15,275.9 8,983.0
Logical reads: 13,716.1 8,065