All rights reserved findingson the automatic database diagnostic monitor addm page

ADDM Findings

Oracle Database 11g: Administration Workshop I 12 - 19

ADDM Recommendations

reduction in database elapsed time if the recommendation is implemented.

The ADDM considers a variety of changes to a system. Its recommendations can include: • 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 the SQL Tuning Advisor on high-load SQL, or running the Segment Advisor on hot objects