-
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
-
Local managed tablespace
You can find the following information very helpful.
[url]http://www.ixora.com.au/tips/creation/extents[/url]
Another option is to use LOCAL MANAGED TABLESPACE so that the extent allocation is done by the RDBMS.
[url]http://www.oracle.com/oramag/oracle/00-nov/index.html?o60o8i.html[/url]
hptse
-
Hi hptse,msnazar
Thanks a lot.
Thanks again
Regards,
Jee
-
jee,
I suggest you serioursly look into the LOCAL MANAGED TABLESPACE option.
hptse
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|