|
|
| Re: Database size [message #60271 is a reply to message #60270] |
Thu, 29 January 2004 06:13   |
Sanjay
Messages: 236
Registered: July 2000
|
Senior Member |
|
|
When you create a database, you create it at a decent size. Then as you start loading data, you increase the tablespace and hence the database grows.
It all depends on how much data is loaded in the system after the creation and how much disk space you have or plan to get.
-
Sanjay
|
|
|
|
| Re: Database size [message #60272 is a reply to message #60270] |
Thu, 29 January 2004 07:48 |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
First off,you'll need to estimate the schema sizes(ie tables/indexes etc) from the data model and the size/growth requirements from the development team. Loading a good amount of sample data will let you project the size estimates for the database when its fully loaded or how it grows. You would then proceed to estimate other things like rollback segments/tablespace , temporary tablespace ,redolog files and other miscellenous stuff based on transcation patterns/volume /requirements.
The same thing goes for sizing the instance..
Chances are that you wont get it right in the 1st attempt becos of the approximations and incomplete requirements.Once you get a better handle on things as the project goes on,you'll be able to tweak/resize things and make them better..
-Thiru
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
