| Need some info Capacity Planning ---- Urgent [message #124592] |
Mon, 20 June 2005 07:13  |
hafeez_splendid
Messages: 15
Registered: June 2005
Location: india
|
Junior Member |
|
|
Hi all,
I need some info regarding the “ Capacity Planning for database “ in a OLTP based application . Typically it’s a 3-tier architecture (web – app – db).I need to develop a design template .
It would be better if anyone can suggest any tool for planning this .It is very urgent
|
|
|
|
| Re: Need some info Capacity Planning ---- Urgent [message #124848 is a reply to message #124592] |
Tue, 21 June 2005 16:13  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
For capacity planning you need to have estimates of how many records you are likely to have in each table. For each table, you can then calculate/estimate the amount of space used by the average row in that table. The easiest way is often to create sample data in some of your big tables and then analyze the table to look at user_tables.AVG_ROW_LEN. Add some extra space to cater for pct_free, pct_used and block overhead.
Don't waste your time working out exact figures for small tables - concentrate on the big ones.
Estimate % growth over time.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
