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

Thread: A Question I do not understand

  1. 02-14-2001, 09:34 PM #1
    One2Free
    One2Free is offline Junior Member
    Join Date
    Jan 2001
    Posts
    5
    I have just passed the Admin Exam recently.
    I have got a question that I do not undestand.

    Among
    INITRANS, PCTFREE, PCTUSED, MAX_EXTENT, NEXT_EXTENT,

    choose two that will affect the concurrency of an oracle data block.
    Reply With Quote Reply With Quote
  2. 02-15-2001, 06:02 AM #2
    One2Free
    One2Free is offline Junior Member
    Join Date
    Jan 2001
    Posts
    5

    Question

    Does "concurrency" mean that "how many connection can access the data block at the same time?", then will INITRANS relate to the questions?

    Reply With Quote Reply With Quote
  3. 02-16-2001, 01:47 AM #3
    hrishy
    hrishy is offline Senior Advisor
    Join Date
    Jan 2001
    Posts
    2,828
    the answer to your question is pctfree and initrans as concurrency here refers to number of simultaneous processes trying to perform an operation on a table.

    refer to oarcle 24 x7 by venkat devraj for further details
    Reply With Quote Reply With Quote
  4. 02-16-2001, 07:09 AM #4
    JOHNZ
    JOHNZ is offline Junior Member
    Join Date
    Jan 2001
    Posts
    31

    Thumbs up CONCURRENT

    The answer should be initrans & maxtrans.
    Please refer to Sybex "Oracle 8i DBA architeture and ADM page 183 or Jason's Book of DBA EXAM393. Welcome correction please.

    [Edited by johnz on 02-16-2001 at 06:13 AM]
    Reply With Quote Reply With Quote
  5. 02-17-2001, 04:47 AM #5
    hrishy
    hrishy is offline Senior Advisor
    Join Date
    Jan 2001
    Posts
    2,828
    hi

    johnz i agree with you about maxtrans but there is no choice here on maxtrans.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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