Solved

Performance capacity planning

Posted on 2010-11-17
5
557 Views
Last Modified: 2012-06-22
What is Performance capacity planning needed as an Oracle DBA. I really appreciate your help. Thanks in advance
0
Comment
Question by:hussainkhan22
  • 3
5 Comments
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 375 total points
ID: 34157830
You need to be concerned with how your database usage will change over time.

This will help decide possible disk, ram, and/or cpu upgrades that may become necessary.
0
 

Author Comment

by:hussainkhan22
ID: 34158261
What exactly does Performance capacity planning means as an Oracle DBA. Thanks in advance for your help
0
 
LVL 7

Assisted Solution

by:jocave
jocave earned 125 total points
ID: 34158480
To some extent, it depends on your organization and exactly what the parameters of the request are.

For example, if you are the DBA responsible for designing a database for a new custom developed system, performance capacity planning would probably involve figuring out how much hardware will be needed over the first few years of the system's life in order to ensure acceptable performance based on the expected number of users.  And that will depend on extrapolating performance that you know about (ideally, the new system's performance in test) out to real production loads but it may depend on extrapolating performance of similar systems.

If you are the DBA overseeing an existing production system, a performance capacity plan probably involves extrapolating the AWR/ Statspack/ operating system statistics you've been gathering over the past few years to determine whether additional hardware is needed.  If average CPU utilization is increasing at a rate of 1% a month, for example, you're probably not far off from a point where you're going to hit the elbow of performance and the system will suddenly get dramatically slower.  On the other hand, if performance has been holding steady for years and there is no projected increase in load, the existing hardware is probably sufficient.  Part of this will also involve figuring out what the performance bottlenecks are in order to determine what sort of hardware to request on what sort of timeline (i.e. perhaps you need an additional node for your RAC cluster in 6 months and a memory upgrade in a year and a disk upgrade in 2 years).

And of course, the more speculative the data you're using, the greater your confidence interval.  It's clearly a lot easier to project the behavior of an existing production system that has been around for years in 6 months than to do the same for a system that you just have a high-level architecture for.
0
 
LVL 76

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 375 total points
ID: 34159294
>>What exactly does Performance capacity planning means as an Oracle DBA

If is not clear from jocave's very well done post.  Like many of your other questions:   What it means to you depends on how your organization is set up.

It can also mean many other things not in jocave's post (or I might have missed it) suceh as: It might mean to monitor SQL to predict possible performance issues if database growth continues.  Maybe you need to help suggest new indexes or removal of 'bad' indexes.

Only your team lead can define this term for you specific to your organization.
0
 
LVL 76

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 375 total points
ID: 34159319
Just thought of another one:  You might also be required to look at splitting up objects into separate tablespaces that may or may not need different block sizes and may or may not need to be on different disks.

We can go on and on with different possibilities and probably still never cover all of them.
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
High Bandwidth Usage 6 56
oracle- set role and grant privileges 6 28
CENTOS DHCP Server / PXE/TFTP 14 77
having some issue on pl sql procedure 1 19
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Google Drive is extremely cheap offsite storage, and it's even possible to get extra storage for free for two years.  You can use the free account 15GB, and if you have an Android device..when you install Google Drive for the first time it will give…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question