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.
Printable View
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.
Does "concurrency" mean that "how many connection can access the data block at the same time?", then will INITRANS relate to the questions?
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
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]
hi
johnz i agree with you about maxtrans but there is no choice here on maxtrans.