Database Tuning (MOSC)

MOSC Banner

gc current block busy

edited May 15, 2012 3:26AM in Database Tuning (MOSC) 6 commentsAnswered
Hi ,

I have two node Oracle RAC.Version is 11.2.0.2

When i do an online inquire transaction for higher load, I am observing 'gc current block busy' in AWR as one of the top events.GV$SESSION_WAIT
doesnt show anything as below.

Kindly let me know how to tune it.

AWR top events.

DB CPU 32 64.34 
log file sync5,9729218.36Commit
gc current block busy2,44872313.32Cluster
gc current block 2-way4,665315.41Cluster
gc current grant busy2,446102.20Cluster

SQL> SELECT
  INST_ID,
  EVENT,
  P1 FILE_NUMBER,
  P2 BLOCK_NUMBER,
  WAIT_TIME
FROM
  GV$SESSION_WAIT
WHERE
  EVENT IN ('buffer busy global cr', 'global cache busy',

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