| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: INITRANS and MAXTRANS
A copy of this was sent to "Matthew D. Heilman" <matthew.d.heilman_at_ac.com>
(if that email address didn't require changing)
On Thu, 28 May 1998 10:22:34 -0400, you wrote:
>This number determines that number of users that can concurrently have a
>transaction on the table.
>
Not really, MAXTRANS determines the number of users that can concurrently have a transaction open on a BLOCK within a table -- not at the table level itself.
INITRANS sets aside a fixed portion of the block for transaction entries (loosely speaking -- who has what rows locked on this block). If insufficient slots are available in the transaction table on a given block at runtime, we will expand the transaction table upto MAXTRANS entries in size if space exists on the block.
Oracle keeps the 'locks' with the data -- the transaction header entries tell us what rows on the block are "locked" by someone. MAXTRANS determines the maximum number of users that can have open transactions on a given block (before blocking will occur, waiting for an empty transaction slot).
>
>Umar FArooq wrote in message <356CFA80.D51A723F_at_cressoft.com.pk>...
>>HI!'
>>Could anyone tell me the purpose of INITRANS and MAXTRANS. The ORacle
>>documentation says that they specify the space for an initial and max
>>number of transactions that can occupy a block. What does this mean and
>>what is the need to reserve space for transactions in each block?
>>
>>Thx in advance.
>>
>>Umar.
>>
>>
>
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Thu May 28 1998 - 12:26:01 CDT
 |
 |