Space calculation

Hi ,

I want to create a table with 50 million records, i would like to know what are the values i should give for storage structures.
for example - initial extent =?
next extent=?
and so on. Please also tell me, is there any calculation behind this. here my database is going to be 10 gb and the db_block_size =4k .

Note: if somebody knows any good books on this topic , pl suggest me.



Thanks and Regards,
jee

Hi,

Space calculation for tables/indexes available in Oracle Database administration Manual.

Based on the avg.row size you can approx.estimate how many rows fit into one Block and then you can calculate the total size approx.

Thanks.

M.S.Nazar

You can find the following information very helpful.
http://www.ixora.com.au/tips/creation/extents

Another option is to use LOCAL MANAGED TABLESPACE so that the extent allocation is done by the RDBMS.

http://www.oracle.com/oramag/oracle/...ml?o60o8i.html

Hi hptse,msnazar

Thanks a lot.

Thanks again

Regards,
Jee

jee,

I suggest you serioursly look into the LOCAL MANAGED TABLESPACE option.