Space calculation
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Space calculation

  1. #1
    Join Date
    Aug 2000
    Posts
    30
    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


  2. #2
    Join Date
    Mar 2001
    Posts
    6
    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

  3. #3
    Join Date
    Mar 2001
    Posts
    22

    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

  4. #4
    Join Date
    Aug 2000
    Posts
    30
    Hi hptse,msnazar

    Thanks a lot.

    Thanks again

    Regards,
    Jee

  5. #5
    Join Date
    Mar 2001
    Posts
    22
    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
  •  


Click Here to Expand Forum to Full Width