Sunday, March 3, 2013

ORACLE - RAC wait events

Oracle  RAC wait events:

select name, values from v$SYSSTAT name like 'g%';
or
View AWR for RAC wait event

Wait event grouped:
Block-oriented
        gc current block 2-way
        gc current block 3-way
        gc cr block 2-way
        gc cr block 3-way

 Message-oriented
        gc current grant 2-way
        gc cr grant 2-way

 Contention-oriented
        gc current block busy
        gc cr block busy
        gc buffer busy

 Load-oriented
        gc current block congested
        gc cr block congested

Resource Contention
       gc cr block busy
       gc current block busy
       gc buffer busy
       gc freelist
      

No comments:

Post a Comment