CHAPTER
8
Database Tuning
241
242 Oracle Database 11g DBA Handbook
rom a tuning perspective, every system has a performance bottleneck that may
move from component to component over a time period of days or even weeks
The goal of performance design is to make sure that the physical limitations of the
applications and the associated hardware??”I/O throughput rates, memory sizes,
query performance, and so on??”do not impact the business performance. If the
application performance limits the business process it is supposed to be supporting, the application
must be tuned. During the design process, the limits of the application environment??”including
the hardware and the design of the application??™s interactions with the database??”must be evaluated.
No environment provides infinite computing capacity, so every environment is designed to fail at
some performance point. In the process of designing the application, you should strive to have
your performance needs amply served by the performance capabilities of the environment.
Performance tuning is a part of the life cycle of every database application, and the earlier
performance is addressed (preferably before going into production), the more likely it will be
successfully resolved. As noted in previous chapters, most performance problems are not isolated
symptoms but rather are the result of the system design. Tuning efforts should therefore focus on
identifying and fixing the underlying flaws that result in unacceptable performance.
Pages:
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404