Very high Avg global cache current block pin time in AWR report (Doc ID 1961394.1)

Last updated on JANUARY 21, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

Symptoms

Very high Avg global cache current block pin time reported in AWR report:

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.8
Avg global cache cr block receive time (ms): 1.6
Avg global cache current block receive time (ms): 1.5
Avg global cache cr block build time (ms): 0.0
Avg global cache cr block send time (ms): 0.0
Global cache log flushes for cr blocks served %: 19.9
Avg global cache cr block flush time (ms): 9.9
Avg global cache current block pin time (ms): 26,521.6     ====>> 26 seconds
Avg global cache current block send time (ms): 0.0
Global cache log flushes for current blocks served %: 6.6
Avg global cache current block flush time (ms): 2,912.2


Global CURRENT Served Stats
Pins = CURRENT Block Pin Operations
Flushes = Redo Flush before CURRENT Block Served Operations
Writes = CURRENT Block Fusion Write Operations
Statistic Total % <1ms % <10ms % <100ms % <1s % <10s
Pins 72 45.83 51.39 2.78 0.00 0.00
Flushes 6,427 8.37 85.78 4.92 0.75 0.19
Writes 5,406 2.76 26.25 68.94 2.05 0.00

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms