question when reading note 139436.1 (cache fusion)
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?