Home > Database 11g, RAC > Gc Buffer Busy Nightmare

Gc Buffer Busy Nightmare

Last week i was facing some irregular contentions issues in one of the RAC cluster that i manage, the problem is very common for DBAs that administer Oracle RAC. The wait “gc buffer busy” is one of the things that you really want to avoid is RAC because it could lead you a total cluster HANG when sessions including oracle internals, are waiting for this.

When a session request changes to blocks that are used by another session either in the local or remote instance, that session stays in a loop waiting for the LMS process to release the lock. If multiple sessions also tries the update the same block, that block will be transfered across the instances and this may lead to what i call in spanish “Un tranque“.

There are a couple of reasons that may increase these waits in a RAC environment and they are very well documented so you can review them if you are experiencing this situation. My problem was caused by highly used sequences that had the default cache size. Setting a higher value for those sequences resolve the issue.

Here are good articles that may help you really understand this:

http://orainternals.wordpress.com/2010/09/27/gc-buffer-busy-waits/

http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:1860222500346889715

Oracle Documentation

Regards

Emmanuel

About these ads
Categories: Database 11g, RAC Tags:
  1. November 2, 2013 at 7:38 am | #1

    ck 指輪

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 123 other followers

%d bloggers like this: