Database - RAC/Scalability (MOSC)

MOSC Banner

11.2.0.3 RAC Scenario

edited Nov 21, 2014 10:00AM in Database - RAC/Scalability (MOSC) 2 commentsAnswered

Dear Experts,

Could you please explain me on the below scenario

I have a two node 11.2.0.3 RAC database. lets assume one of the user is connected to the node 1 and performing the update operation on one of the table. In this scenario, The block which needs to update will be pulled into the memory by performing an I/O operation with the disk and will update the value ( Correct me if i am wrong) . Please stop by here

1) If second user connected from node 2 is trying to update the same block. I understood Global cache fusion will come into picture and will wait for the first user to commit ( I believe gc_cr_request and gc_buffer_busy are the wait events here). 

Tagged:

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