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....
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
Click Here to Expand Forum to Full Width