Printable View
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
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)
Hi
You should try searching the forums here.
http://www.dbasupport.com/oracle/maq_vol.xls
courtesy our expert DBA Pando ;-)
regards
Hrishy
How about just creating some tables and slapping in sample data, then measuring? works for me.
LMT, extents 1MB....done
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. :rolleyes: :rolleyes: :rolleyes:
I changed the process to use uniform extents even though were were still using DMT.
thanks! for the spreadsheet quick question on the column to be filled out be the developer, how do you estimate the table data size?Quote:
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
Average Rowsize * number of rows.Quote:
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?
Thanks a lot! what a great team we have here:)Quote:
Originally posted by gandolf989
Average Rowsize * number of rows.
You must be new.Quote:
Originally posted by imose
Thanks a lot! what a great team we have here:)
ROTFLMAOQuote:
Originally posted by Mr.Hanky
You must be new.