Global Cache and Enqueue Services statistics
Date: Mon, 30 Jul 2012 16:15:44 -0400
Message-ID: <304F58144267C5439E733532ABC9A3A115994C7E_at_USA0300MS02.na.xerox.net>
Folks,
I have a three-node Oracle RAC environment running on Solaris 10. The Grid and DB versions are 11.2.0.3 and 11.1.0.7 respectively. We ran a load test against the environment to simulate our load in production. The transaction timings were off when compared to timings from the single instance of the same environment. When I look at AWR from all instances, the following workload statistics seem a bit high:
Avg message sent queue time
Avg global cache current block receive time (ms)
Avg global cache cr block flush time
The CPU utilization was over 90% idle on each RAC node during the test. The interconnect is an aggregated link of two 10GbE NIC. Database files are on RAID-5 SSDs where as redo logs are on dedicated RAID-10 SAS drives. Is there anything that I should look at closely that could help identify reason for higher timings for these statistics? Also, what is considered as good timing for these statistics?
Thank you,
Amir
Instance #1
Global Cache and Enqueue Services - Workload Characteristics
Avg global enqueue get time (ms): 1.4 Avg global cache cr block receive time (ms): 3.7 Avg global cache current block receive time (ms): 13.0 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 %: 8.0 Avg global cache cr block flush time (ms): 7.5 Avg global cache current block pin time (ms): 6.2 Avg global cache current block send time (ms): 0.3 Global cache log flushes for current blocks served %: 13.4 Avg global cache current block flush time (ms): 5.1
Global Cache and Enqueue Services - Messaging Statistics
Avg message sent queue time (ms): 7736.8
Instance #2
Global Cache and Enqueue Services - Workload Characteristics
Avg global enqueue get time (ms): 0.8 Avg global cache cr block receive time (ms): 2.2 Avg global cache current block receive time (ms): 11.2 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 %: 6.8 Avg global cache cr block flush time (ms): 12.0 Avg global cache current block pin time (ms): 10.5 Avg global cache current block send time (ms): 0.3 Global cache log flushes for current blocks served %: 15.0 Avg global cache current block flush time (ms): 6.4
Global Cache and Enqueue Services - Messaging Statistics
Avg message sent queue time (ms): 9120.8
Instance #3
Global Cache and Enqueue Services - Workload Characteristics
Avg global enqueue get time (ms): 0.6 Avg global cache cr block receive time (ms): 2.9 Avg global cache current block receive time (ms): 10.4 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 %: 7.1 Avg global cache cr block flush time (ms): 9.6 Avg global cache current block pin time (ms): 14.3 Avg global cache current block send time (ms): 0.3 Global cache log flushes for current blocks served %: 14.5 Avg global cache current block flush time (ms): 6.5
Global Cache and Enqueue Services - Messaging Statistics
Avg message sent queue time (ms): 8390.3
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jul 30 2012 - 15:15:44 CDT