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