Hi all does any one have a spreadsheet for table sizing?

[imose]

Good morning,
I am looking for a spreadsheet that can be used to compute the size of tables. I am creating new database schemas and each table is going to have 100000 rows. I previously had a spread sheet that can be used to compute the amount of space needed. If anyone has one I would really appreciate it!
thanks!

oracle 10g, 8i

[davey23uk]

only you can work that out. Dependant on the number of columns, row size etc..

Or do you want something that you plug in all the relevant values and it comes up with an naswer (be quicker to write it yourself)

[hrishy]

Hi

You should try searching the forums here.

http://www.dbasupport.com/oracle/maq_vol.xls

courtesy our expert DBA Pando ;-)

regards
Hrishy

[slimdave]

How about just creating some tables and slapping in sample data, then measuring? works for me.

[Mr.Hanky]

LMT, extents 1MB....done

[gandolf989]

I once worked for a company that used a spreadsheet. It tried to cram all of the data into one extent, allowing it a second extent if it needed it, a Ouija board would have done as well.

I changed the process to use uniform extents even though were were still using DMT.

[imose]

Originally posted by hrishy
Hi

You should try searching the forums here.

http://www.dbasupport.com/oracle/maq_vol.xls

courtesy our expert DBA Pando ;-)

regards
Hrishy

thanks! for the spreadsheet quick question on the column to be filled out be the developer, how do you estimate the table data size?

[gandolf989]

Originally posted by imose
thanks! for the spreadsheet quick question on the column to be filled out be the developer, how do you estimate the table data size?

Average Rowsize * number of rows.

[imose]

Originally posted by gandolf989
Average Rowsize * number of rows.

Thanks a lot! what a great team we have here

[Mr.Hanky]

Originally posted by imose
Thanks a lot! what a great team we have here

You must be new.