Oracle - AWR - 教你如何看 - 图文(2)

Global Cache Load Profile

Global Cache blocks received: Global Cache blocks served: GCS/GES messages received: GCS/GES messages sent: DBWR Fusion writes: Estd Interconnect traffic (KB) Per Second 4.16 5.97 408.47 258.03 0.05 211.16 Per Transaction 3.51 5.04 344.95 217.90 0.05 Global Cache Efficiency Percentages (Target local+remote 100%)

Buffer access - local cache %: Buffer access - remote cache %: Buffer access - disk %: 98.60 0.12 1.28 Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): Avg global cache cr block receive time (ms): Avg global cache current block receive time (ms): Avg global cache cr block build time (ms): Avg global cache cr block send time (ms): Global cache log flushes for cr blocks served %: Avg global cache cr block flush time (ms): Avg global cache current block pin time (ms): Avg global cache current block send time (ms): Global cache log flushes for current blocks served %: Avg global cache current block flush time (ms): 0.1 1.1 0.8 0.0 0.0 3.5 3.9 0.0 0.0 0.4 3.0 Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): Avg message sent queue time on ksxp (ms): Avg message received queue time (ms): Avg GCS message process time (ms): Avg GES message process time (ms): % of direct sent messages: % of indirect sent messages: % of flow controlled messages: 0.0 0.3 0.5 0.0 0.0 14.40 77.04 8.56 Main Report ? ? Wait Events Statistics SQL Statistics ? ? ? ? ? ? ? ? ? ? ? ? ? ? Instance Activity Statistics IO Stats Buffer Pool Statistics Advisory Statistics Wait Statistics Undo Statistics Latch Statistics Segment Statistics Dictionary Cache Statistics Library Cache Statistics Memory Statistics Streams Statistics Resource Limit Statistics init.ora Parameters Wait Events Statistics