INITRANS Forums - Powered by vBulletin
Results 1 to 2 of 2


  1. #1
    Join Date
    Feb 2001
    hi all,

    if i set a very high value of the initrans does it also affects the number of rows that a block can hold???

    i beleive that it has a computation :

    a block = common and variable + table directory + row directory + row data + free space.

    a block = 24b (common) + (24 * initrans) b + 4b + (4 * no of rows) b + row data + free space

    is this correct....

  2. #2
    Join Date
    Feb 2001
    Paris, France
    formula given by Oracle for calculating the size in bytes of a block's header is :


    all of these parameters are found in v$type_size.
    that way you can know what if the exact influence of initrans on your block's empty space

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width