DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: locks

  1. #1
    Join Date
    Feb 2002
    Posts
    267
    hi folks,
    what does s-lock and ss-lock stands for.

  2. #2
    Join Date
    Dec 2001
    Posts
    320

  3. #3
    Join Date
    Feb 2002
    Posts
    267
    hi

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

    regards
    sonia

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    ss == sub-share == lock rows in shared mode
    s == share == lock table in shared mode

    all documentated in concept guide

  6. #6
    Join Date
    Feb 2002
    Posts
    267
    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
  •  


Click Here to Expand Forum to Full Width