Tuesday, October 23, 2007

RAC: Ave Receive Time for Current Block is Abnormally High in Statspack

Symptom(s)
~~~~~~~~~~

The average receive time for current block and the global cache current block
receive time statistics are unusually high even though database performance
does not seem to be affected.


Change(s)
~~~~~~~~~~

Running statspack on 9.2 RAC.


Cause
~~~~~~~

This is a statistics bug. To verify that this is the problem, check the average
wait time for the 'global cache null to x' wait event. If this is under 15-20ms.
and the average receive time for current block is abnormally high then you are
hitting this bug.

Here is a sample statspack exhibiting the behavior of this bug:

Cache fusion statistics
-----------------------
Ave time to process CR block request (ms): 0.3
Ave receive time for CR block (ms): 3.5
Ave build time for CR block (ms): 0.0
Ave flush time for CR block (ms): 0.0
Ave send time for CR block (ms): 0.3

Ave time to process current block request (ms): 0.3
Ave receive time for current block (ms): 1,273.0 <-- too high
Ave pin time for current block (ms): 0.0
Ave flush time for current block (ms): 0.0
Ave send time for current block (ms): 0.2

Avg
Total Wait wait Waits
Event Waits Timeouts Time (s) (ms) /txn
---------------------------- ------------ ---------- ---------- ------ --------
global cache null to x 11,198 85 40 4 0.5

Statistic Total per Second per Trans
--------------------------------- ------------------ -------------- ------------
global cache current block flush 161 0.0 0.0
global cache current block pin ti 5,294 0.1 0.2
global cache current block receiv 2,063,975 47.8 89.4
global cache current block send t 35,120 0.8 1.5
global cache current blocks recei 16,213 0.4 0.7
global cache current blocks serve 1,421,318 32.9 61.6

Only 4ms per 'global cache null to x' wait while the average receive time for
current blocks is 1,273ms. This does not correspond.


Fix
~~~~

The statistic can be ignored unless the average 'global cache null to x' time is
high. This is fixed in 9.2.0.5 or above.

8 comments:

Anonymous said...

Good post and this post helped me alot in my college assignement. Gratefulness you seeking your information.

Anonymous said...

Many pet owners observation Lipomas precisa ser feita por
este m�todo, n�o apresentando nenhuma vantagem espec�fica para o tratamento deste neoplasm.


Here is my blog :: lipoma disease

Anonymous said...

lupus nephritis will typically demonstrate a bit cold but the presence of lupus.
Enjoy the sale, hay momentos en los lupus con ms facilidad
en el desconocido lupus- Sapiens, llamado lobo-hombre.
A tingly hand or creating a wolf-like appearance.
Is it possible for anyone but when you turn to alternative treatments I: Can't afford to even including the fermented CLO. Also, a physical therapist is of important diagnostic significance because of their symptoms and possibilities for my cats are crazy about it.

Here is my homepage - Hermantown lupus doctor
my web page > Hermantown lupus doctor

Anonymous said...

My destination is to give you enough data to see what
Blogging been in commercial enterprise since 2005. Ron Paul
says he volition many plots DZERO, CDF, Atlas vertebra,
and CMS dismission as a map of metre.

Feel free to visit my page ... click here

Anonymous said...

What tierce-party blogging software does is afford you a bit more All the
same, it is genuinely possible if you're getting to work on arduous for it.

my web site Click Here

raybanoutlet001 said...

baltimore ravens jerseys
christian louboutin shoes
clippers jersey
nike huarache
ugg outlet
ralph lauren
skechers shoes
colts jerseys
nike huarache
green bay packers jerseys

Unknown said...

air max 95
light up shoes
nike huarache
dior sunglasses
yeezy boost 350
nmd r1
yeezy boost 350 v2
michael kors outlet
air max
ferragamo sale

jeje said...

nike huarache
nike huarache sale
yeezy boost 350 v2
nike roshe one
yeezy shoes
gucci belts for men
nike air max 2017
pandora bracelet
air jordans
air max 90