OraFAQ Forum: Server Administration » Estimate database size

Home » RDBMS Server » Server Administration » Estimate database size (10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Estimate database size [message #296025]

Thu, 24 January 2008 04:17

vishal gupta
Messages: 111
Registered: March 2001

Senior Member

Hi,
How to estimate size of new Oracle database ?

Regards

Report message to a moderator

Re: Estimate database size [message #296026 is a reply to message #296025]

Thu, 24 January 2008 04:28

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Summing all the fields multiplying by the number of rows for each table and each index and adding 10% for overhead then adding the system, sysaux, undo, temp tablespaces.

Regards
Michel

Report message to a moderator

Re: Estimate database size [message #296237 is a reply to message #296025]

Fri, 25 January 2008 03:53

vishal gupta
Messages: 111
Registered: March 2001

Senior Member

Hi,
Is there any diff. between Production and Development database environments ?
If yes,what should be the differentiating criteria ?
I mean,what are the things in Production which we should not consider for development environments ?

regards

Report message to a moderator

Re: Estimate database size [message #296242 is a reply to message #296237]

Fri, 25 January 2008 04:31

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Is there any diff. between Production and Development database environments ?

Tell us. It is your data.

Quote:

what are the things in Production which we should not consider for development environments ?

About size? There are less data in development I assume.

Regards
Michel

Report message to a moderator

Previous Topic:	Error
Next Topic:	valus in init.ora file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 28 00:46:22 CST 2025