Formula for Maximum Row Length (Not Average) required.
Does any one you have the formula or procedure to calculate the maximum row length (not the average) of a table which includes the following parameters as well.
DB Block Size, KCBH, UB4, KTBBH, KTBIT, KDBH, SB2, UB1, INITVAR, PCTFREE, INITTRANS, BLOCK HEADER, ROW HEADER
I can find some of the above values from v$type_size and calculate the others, i don't want to reinvent the wheel (feeling lazy), if any one has already any formula or link for this please post it.
"There is a difference between knowing the path and walking the path."
Click Here to Expand Forum to Full Width