ADDM Recommendations

In addition to diagnosing performance problems, ADDM recommends possible solutions. When appropriate, ADDM recommends multiple solutions from which you can choose. ADDM recommendations include the following:

• Hardware changes

  Adding CPUs or changing the I/O subsystem configuration

• Database configuration

  Changing initialization parameter settings

• Schema changes

  Hash partitioning a table or index, or using automatic segment space management (ASSM)

• Application changes

  Using the cache option for sequences or using bind variables

• Using other advisors

  Running SQL Tuning Advisor on high-load SQL statements or running the Segment Advisor on hot objects

ADDM benefits apply beyond production systems. Even on development and test systems, ADDM can provide an early warning of potential performance problems.

Performance tuning is an iterative process. Fixing one problem can cause a bottleneck to shift to another part of the system. Even with the benefit of the ADDM analysis, it can take multiple tuning cycles to reach a desirable level of performance.