locks

[Sonia]

hi folks,
what does s-lock and ss-lock stands for.

[hany]

hi Sonia,
Read: http://otn.oracle.com/docs/products/...dexes.htm#3062

Best Regards.

[Sonia]

hi

what does s-lock stands for or ss-stands for

regards
sonia

[julian]

Originally posted by Sonia
hi

what does s-lock stands for or ss-stands for

regards
sonia

ss-lock means subshared lock. It allows unprotected reading. If you run for example a 2-node OPS/RAC, node 1 might hold the lock on a block in ss-mode and node 2 may be able to read and even modify the block.

s-lock means shared lock. The difference between ss-lock is that no instance can write/modify the block. Just for reading.

If you are curious, the rest of the locks are null-locks, sx-lock (shared exclusive), ssx-locks (subshared exclusive) and x-locks (exclusive).

[pando]

ss == sub-share == lock rows in shared mode
s == share == lock table in shared mode

all documentated in concept guide

[Sonia]

thanx julian...
the info really helped me