Table sizing question
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Table sizing question

  1. #1
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586

    Table sizing question

    Hi.I wanted to find out how you figure out how much in Megs or Gb a table would aquire after creating and populating with data if we knew the following...

    1. data types numbers and varchars2
    2. Estimated space would take 3.5 Million rows.

    how would u find out
    1. What the initial and next would be?

    -Jigar
    "High Salaries = Happiness = Project Success."

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    1. Put 1000 rows in the table with representitive data
    2. analyze compute statistics
    3. look at avg row size
    4. multiply by 3.5 million
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Originally posted by marist89
    1. Put 1000 rows in the table with representitive data
    2. analyze compute statistics
    3. look at avg row size
    4. multiply by 3.5 million
    If you had a pctfree much greater than zero, you might like to work out total space requirement by multiplying ...

    "BLOCKS" * ts block size * 3500
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

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