Home » RDBMS Server » Server Administration » Estimate database size (10g)
Estimate database size [message #296025] Thu, 24 January 2008 04:17 Go to next message
vishal gupta
Messages: 111
Registered: March 2001
Senior Member
Hi,
How to estimate size of new Oracle database ?

Regards
Re: Estimate database size [message #296026 is a reply to message #296025] Thu, 24 January 2008 04:28 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Estimate database size [message #296237 is a reply to message #296025] Fri, 25 January 2008 03:53 Go to previous messageGo to next message
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
Re: Estimate database size [message #296242 is a reply to message #296237] Fri, 25 January 2008 04:31 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Error
Next Topic: valus in init.ora file
Goto Forum:
  


Current Time: Mon Dec 05 15:16:13 CST 2016

Total time taken to generate the page: 0.06869 seconds