Printable View
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
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 ...Quote:
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
"BLOCKS" * ts block size * 3500