How will you estimate the space required by a non-clustered tables?
Submitted by: AdministratorCalculate 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.
Submitted by: Administrator
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.
Submitted by: Administrator
Read Online Memory Management Job Interview Questions And Answers
Top Memory Management Questions
☺ | How does Space allocation table place within a block? |
☺ | What is the role of PCTFREE parameter is storage clause? |
☺ | What is the use of INDEXES option in IMP command? |
☺ | What is the OPTIMAL parameter? |
☺ | What is the significance of having storage clause? |
Top DB Oracle Categories
☺ | Oracle PL-SQL Interview Questions. |
☺ | Oracle DBA Interview Questions. |
☺ | Oracle D2K Interview Questions. |
☺ | OCI Interview Questions. |
☺ | Oracle RMAN Interview Questions. |