Database - RAC/Scalability (MOSC)

MOSC Banner

question when reading note 139436.1 (cache fusion)

edited Sep 19, 2011 8:00PM in Database - RAC/Scalability (MOSC) 6 commentsAnswered

Hi All,

When I read the note 139436.1 in metalink, the following statement made me confused.

{code}
Let's assume there is a 3 node RAC cluster and with lock element 123 covering a
block in the EMP table:

User C issues a select against table EMP lock element 123 on Instance 3 which opens
an SL0 lock on Instance 3:

    ----------------      -----------------     ----------------- 
    |  Instance 1   |     | Instance 2    |    |  Instance 3    |
    |               |     |               |    |                |
    |   Lock Held   |     |   Lock Held:  |    |   Lock Held:   |
    | on LENUM 123: |     | on LENUM 123: |    | on LENUM 123:  |
    |               |     |               |    |      SL0       |
    |               |     |               |    |                |
    ----------------      -----------------     ----------------- 

{code}

As far as I know, no lock will be incurred for query. Why does this note say one shared lock will be opened?

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