hi folks,
what does s-lock and ss-lock stands for.
Printable View
hi folks,
what does s-lock and ss-lock stands for.
hi Sonia,
Read: http://otn.oracle.com/docs/products/...dexes.htm#3062
Best Regards.
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.Quote:
Originally posted by Sonia
hi
what does s-lock stands for or ss-stands for
regards
sonia
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).
ss == sub-share == lock rows in shared mode
s == share == lock table in shared mode
all documentated in concept guide
thanx julian...
the info really helped me