-
hi folks,
what does s-lock and ss-lock stands for.
-
-
hi
what does s-lock stands for or ss-stands for
regards
sonia
-
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).
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|