Global Cache and Enqueue Services statistics

From: Hameed, Amir <Amir.Hameed_at_xerox.com>
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-l
Received on Mon Jul 30 2012 - 15:15:44 CDT

Original text of this message