Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    26

    Unanswered: Block Contention

    Hi People,

    Could you please clarify what is Block Contention ?

    Is it when 2 or more processes need to access the same Oracle block at the same time.

    Does block contention occur only during updates/deletes or does it occur even during selects

    Pls clarify
    TIA
    Arvind

  2. #2
    Join Date
    Sep 2003
    Location
    Milan, Italy
    Posts
    130

    Re: Block Contention

    Originally posted by arvindl
    Hi People,

    Could you please clarify what is Block Contention ?

    Is it when 2 or more processes need to access the same Oracle block at the same time.

    Does block contention occur only during updates/deletes or does it occur even during selects

    Pls clarify
    TIA
    Arvind
    The definition is perfect, occurs also for index blocks.

    When a process needs to read a block, it must flag it as "being read", to prevent someone else to write it at the same time. But others can read at the same time, too (this is called SHARED "locking").

    When a process needs to write into a block, it must flag it as "being written", and no other process can read or write to it (this is called EXCLUSIVE "locking").

    So it happens anytime one has to read or write (in a word, access) and another is currently reading or writing (with the exception of read/read collision).

    Al

Posting Permissions

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