OraFAQ Forum: Performance Tuning » Need some info Capacity Planning ---- Urgent

Home » RDBMS Server » Performance Tuning » Need some info Capacity Planning ---- Urgent

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

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

Report message to a moderator

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.

Report message to a moderator

Previous Topic:	How to increase Performance of Composite Primary Key
Next Topic:	How to optimize this sql

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 09:11:29 CDT 2025