DEVFYI - Developer Resource - FYI

How will you estimate the space required by a non-clustered tables?

ORACLE Interview Questions and Answers (Part 2)


(Continued from previous question...)

335. How will you estimate the space required by a non-clustered tables?

Calculate the total header size
Calculate the available dataspace per data block
Calculate the combined column lengths of the average row
Calculate the total average row size.
Calculate the average number rows that can fit in a block
Calculate the number of blocks and bytes required for the table.
After arriving the calculation, add 10 % additional space to calculate the initial extent size for a working table.

(Continued on next question...)

Other Interview Questions