Q
Problem solve Get help with specific problems with your technologies, process and projects.

INITRANS and MAXTRANS explained

Could you explain to me in detail about INITRANS and MAXTRANS? Books I've read on this topic are not clear.
 

Oracle stores information about row locks in the database block containing the row. The structure containing the information is known as the Interested Transaction List, or ITL. The ITL contains the ID of the transaction that has modified (and therefore locked) a row, and the ID of the row. Space for the ITL in each block is reserved at block creation time, based on the INITRANS and MAXTRANS parameters. INITRANS specifies how many "slots" are initially allocated in a block's ITL. When the number of transactions affecting a single block exceeds the number of existing ITL slots, Oracle will allocate space for more slots if possible, up to the value of MAXTRANS.
 

Dig Deeper on Oracle database performance problems and tuning

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close