DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: INITRANS

  1. #1
    Join Date
    Feb 2001
    Posts
    82
    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
    Location
    Paris, France
    Posts
    809
    formula given by Oracle for calculating the size in bytes of a block's header is :

    header=kcbh+ub4+(initrans-1)*ktbit+kdbh

    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