a problem about data block
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: a problem about data block

  1. #1
    Join Date
    Dec 2000
    Posts
    22
    this is problem about data block at real oracle 8i ocp exam.
    i don't sure the right answer, please explain
    Which two prameter might affect the concurrency of transactions on a data block? (choose two)
    A.PCTUSED
    B.PCTFREE
    C.INITRANS
    D.MAX_EXTENTS
    E.NEXT_EXTENTS
    i choose : B,C
    i put the problem at ocp furmus, but no one answer, hope have answer at here.

  2. #2
    Join Date
    Jun 2001
    Posts
    9

    Here is the solution

    Hi,
    Your answer is exactly correct. The lock contention is depends on INITRANS & PCTFREE .
    The first is no of transactions can update that datablock simultaneously is depends on INITRANS.
    The second one is if u set INITRANS to more than 1, it allows two TX's can update on that datablock. then the contention is switched to the available space, to update the row(s). If u have not enough space to update the row(s), it causes the TX to wait. The space available for update is defined by PCTFREE.
    Other parameters are not related.

  3. #3
    Join Date
    Jan 2001
    Posts
    2,828
    your answer is right...............you can refer oracle 24X7 tips and techniques for the explanation..........................

    regards
    hrishy

  4. #4
    Join Date
    Dec 2000
    Posts
    22
    thank you very much for vutukuri and hrishy

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