Home » RDBMS Server » Server Administration » Calculating storage space
Calculating storage space [message #56329] Wed, 19 March 2003 12:37 Go to next message
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 #56332 is a reply to message #56329] Wed, 19 March 2003 13:43 Go to previous messageGo to next message
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
Senior Member
hello,

I would suggest u to follow what u hav mentioned..
thats it .. :) Also see what others say on this..

sai
Re: Calculating storage space [message #56336 is a reply to message #56329] Thu, 20 March 2003 06:06 Go to previous message
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.
Previous Topic: datafile I/O problem
Next Topic: memory's problem
Goto Forum:
  


Current Time: Fri Sep 20 03:48:16 CDT 2024