Home » RDBMS Server » Performance Tuning » Need some info Capacity Planning ---- Urgent
Need some info Capacity Planning ---- Urgent [message #124592] Mon, 20 June 2005 07:13 Go to next message
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 Go to previous message
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.
Previous Topic: How to increase Performance of Composite Primary Key
Next Topic: How to optimize this sql
Goto Forum:
  


Current Time: Sun Sep 20 23:01:27 CDT 2020