Database - RAC/Scalability (MOSC)

MOSC Banner

9.2.0.8 AIX RAC database. "global cache cr request"

edited Aug 16, 2011 3:15AM in Database - RAC/Scalability (MOSC) 3 commentsAnswered
We having 9.2.0.8 2node RAC database on IBM AIX using HACMP clusterware.
In top 5 wait events "global cache cr request" constitutes more than 50% of total wait events on both the nodes.

Top 5 Timed Events
~~~~~~~~~~~~~~~~~~                                                     % Total
Event                                               Waits    Time (s) Ela Time
-------------------------------------------- ------------ ----------- --------
global cache cr request                         2,573,964      66,591    54.66
db file sequential read                         3,446,319      35,953    29.51
CPU time                                                        6,938     5.70
buffer busy global CR                             104,478       3,067     2.52
buffer busy waits                                 152,072       2,314     1.90
          -------------------------------------------------------------
Cluster Statistics for DB: DMS  Instance: DMS1  Snaps: 18928 -18929

Global Cache Service - Workload Characteristics
-----------------------------------------------
Ave global cache get time (ms):                           13.1
Ave global cache convert time (ms):                       33.4

Ave build time for CR block (ms):                          0.0
Ave flush time for CR block (ms):                          0.2

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center