Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    8

    Unanswered: page level locking/row level locking

    Does Oracle differentiate between row and page level locking? If so, would this be set at the schema or table level?

    Thanks,

    Sean

  2. #2
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    Youll be glad to hear Oracle never does page locking and never escalates row level locks. You can lock a full table explicitly but there are very few cases where you need it. Dont forget in Oracle, readers never block readers or writers, and writers dont block other readers or writers unless they are writing to the same rows.

    Alan

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •