AQ Enqueue / Dequeue Benchmark on RAC 188.8.131.52 Shows Slowdown and Higher CPU
Last updated on MAY 04, 2017
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
Information in this document applies to any platform.
Performance issue affecting AQ applications where they have upgraded to 220.127.116.11 from 10.2.0.4; AQ activity is centred around enqueue / dequeue activity on a RAC environment.
It should be stated that most application are unlikely to be affected by the issues below .
Main observations :
- performance degradation with RAC is greater than with single instance;
slow down with single instance is also observed;
- commit activity appears to be taking longer;
- higher CPU observed;
- AWR report indicates higher statistic values in relation to the following for
the same test in 11g :
In the library cache activity ( RAC ) section of the AWR reports there is increased activity with respect to the following (same benchmark test) :
|statistic||10.2.0.4 value||18.104.22.168 value|
|ges pin requests||192||603829 ( TABLE )|
|ges messages sent||2423||5670|
|global enqueue gets sync||1312577||2315879|
|global enqueue releases||1309834||2313511|
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms