Calculating storage space [message #56329] |
Wed, 19 March 2003 12:37 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Siddu
Messages: 6 Registered: January 2000
|
Junior Member |
|
|
how do i calculate the storage space needed for storing 5 tables in my db... I know it depends on the row size, number of rows and other stuff...
Can anyone suggest some info on this...
Siddu
|
|
|
|
Re: Calculating storage space [message #56336 is a reply to message #56329] |
Thu, 20 March 2003 06:06 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
psmyth
Messages: 81 Registered: October 2002
|
Member |
|
|
i am aware that Oracle have equations to calculate this kind of stuff, but to be honest, it's often simplest just to create the tables and fill them with some test data and measure that.
You'll need to take into account indexes, row chaining pct free etc, but at least you have valid figures to start with.
|
|
|