Block Utilization Parameter
Block space utilization parameters can be used to control the space usage in index and data segments.
INITRANS
INITRANS specifies the initial number of transaction slots created in index or database blocks. The transaction slots are used to store the information about the transactions actively making changes to the block at a point in time. Any transaction uses only one transaction slot in a data block regardless of the number of rows or index entries being made by the transaction.
INITRANS defaults to 1 for data segments' database blocks, and 2 for index segments. This guarantees a minimum level of concurrency. If necessary, additional transaction slots can be allocated for the free space in the data block to allow ...
Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
