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
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