If the environment
is stable, you should be able to quickly accomplish two goals:
1. Successfully re-create the performance problem.
2. Successfully isolate the cause of the problem.
FIGURE 8-3 Automatic SQL Tuning Advisor results
276 Oracle Database 11g DBA Handbook
To achieve these goals, you may need to have a test environment available for your
performance tests. Once the problem has been successfully isolated, you can apply the steps
outlined in this chapter to the problem. In general, your tuning approach should mirror the order
of the sections of this chapter:
1. Evaluate application design.
2. Tune SQL.
3. Tune memory usage.
4. Tune data storage.
5. Tune data manipulation.
6. Tune physical and logical storage.
7. Tune network traffic.
Depending on the nature of your application, you may choose a different order for the steps,
or you may combine steps.
If the application design cannot be altered and the SQL cannot be altered, you can tune the
memory and disk areas used by the application. As you alter the memory and disk area settings,
you must be sure to revisit the application design and SQL implementation to be sure that your
changes do not adversely impact the application. The need to revisit the application design
process is particularly important if you choose to use a data replication method, because the
timeliness of the replicated data may cause problems within the business process served by the
application.
Pages:
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468