How can we plan storage for very large tables ?

Question Posted / guest

How can we plan storage for very large tables ?..

Answer / ravi dutta

we can increase the size of the database block in the
parameter file (init.ora).

Is This Answer Correct ?

1 Yes

0 No

More Oracle Architecture Interview Questions

What is the significance of having storage clause ?

What is the use of Oracle Control File?

What is Cursor?

How to find the current session sid

What is the OPTIMAL parameter ?

Which parameter in Storage clause will reduce no. of rows per block?

1.Explain the three levels with the help og a diagram.

What is the role of PCTFREE parameter is Storage clause ?

How to find the SGA Size

What is User Process?

How to calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?

How to define Data Block size in Oracle?

For more Oracle Architecture Interview Questions Click Here