Home » RDBMS Server » Performance Tuning » Why Performance and Tuning is important
Why Performance and Tuning is important [message #108997] Mon, 21 February 2005 01:42 Go to next message
Mustafa
Messages: 6
Registered: June 2002
Junior Member
Hello everyone,

I need a document which explains why we emphysis so much on Performance and Tuning in details and some technical aspects of Oracle Parformance and Tuning.

I need them fast.

Regards
Re: Why Performance and Tuning is important [message #109897 is a reply to message #108997] Tue, 01 March 2005 14:43 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Hi,

Some of the reasons:

1. The speed of computing might be wasting valuable human time (users waiting for response);

2. Enable your system to keep-up with the speed business is conducted; and

3. Optimize hardware usage to save money (companies are spending millions on hardware).

For more info, see chapter 1 (Performance Tuning Overview) of the Oracle Database Performance Tuning Guide.

Best regards.

Frank
Re: Why Performance and Tuning is important [message #109899 is a reply to message #108997] Tue, 01 March 2005 14:48 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Mustafa wrote on Mon, 21 February 2005 08:42

I need them fast.

Laughing Exactly the same reason why people want their databases tuned! You gave the perfect answer Very Happy.

MHE
Re: Why Performance and Tuning is important [message #109900 is a reply to message #108997] Tue, 01 March 2005 14:53 Go to previous messageGo to next message
pgongloo
Messages: 8
Registered: February 2005
Junior Member
Performance Tuning is as important as High Availability of the system for some businesses. For example, for a brokerage or internet business' like Fidelity, Amazon.com or eBay.com, inability to do service user requests results in lost revenue. Not having a performant system for a few days during holiday season, would mean serious trouble. For this reason, not only they need to pay attention to HA but also, for SLAs during peak processing time.

Performance Tuning is also important, since throwing more CPU and memory doesn't solve underlying problems (for e.g., bad applicaiton design, or SQL). Getting to the root cause is important in these cases...
Re: Why Performance and Tuning is important [message #109936 is a reply to message #108997] Wed, 02 March 2005 01:52 Go to previous message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Quote:

since throwing more CPU and memory doesn't solve underlying problems

...even worse, this could make your application go even slower !
Previous Topic: Does Increasing Field Length Decrease Perf?
Next Topic: on consumption of resources
Goto Forum:
  


Current Time: Thu Mar 28 06:42:23 CDT 2024