Results 1 to 6 of 6

Thread: Table Sizing

  1. #1
    Join Date
    Feb 2004
    Posts
    22

    Question Unanswered: Table Sizing

    I am in the process of creating oracle tables. I know the number of records for each table.

    Is there any oracle table sizing sheet where I plug in the data and obtain the required table sizing ?

    Aravind

  2. #2
    Join Date
    Dec 2003
    Posts
    1,074

    Re: Table Sizing

    Originally posted by aravindvin
    I am in the process of creating oracle tables. I know the number of records for each table.

    Is there any oracle table sizing sheet where I plug in the data and obtain the required table sizing ?

    Aravind
    I think TOAD will do this for you.
    -cf

  3. #3
    Join Date
    Feb 2004
    Posts
    22

    Re: Table Sizing

    Originally posted by chuck_forbes
    I think TOAD will do this for you.
    -cf
    Say if TOAD specifies that size should be 100K, then what should I give for

    1. Initial Extent
    2. Next extent
    3. Pct Increase.

    I am using the tables only for temporary migration purposes. Not used for any application or anything like that.

    Aravind

  4. #4
    Join Date
    Jul 2003
    Location
    England
    Posts
    152
    If you are only using the table for temp migration, I would suggest making the inital extent big eough to hold all the data (100K in your example). Make next the same if you like (100k), and set pctincrease to 0

    Just suggestions ..
    Regards
    Dbabren

  5. #5
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Here's a little script that you can run to "guesstimate" the size of the table.... That is assuming that you know the number of columns and the average row size and the number of rows in the table...

    For next_extent ... determine how many rows fit in a block, how many more rows will be added to the table and go from there ...

    HTH
    Gregg
    Attached Files Attached Files

  6. #6
    Join Date
    Dec 2003
    Posts
    1,074
    Originally posted by gbrabham
    Here's a little script that you can run to "guesstimate" the size of the table.... That is assuming that you know the number of columns and the average row size and the number of rows in the table...

    For next_extent ... determine how many rows fit in a block, how many more rows will be added to the table and go from there ...

    HTH
    Gregg
    If you're letting Oracle manage your extents, you shouldn't need to specify a STORAGE clause for your table, correct?

    -Chuck

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •