Investigate performance issues with DPA

DPA uses an approach called wait-based analysis to help you focus on issues that provide the greatest performance improvements. Query advisors and table tuning advisors identify performance issues and help you find the root cause:

• Access DPA query or table tuning advisors
• Use DPA's query performance analysis to find the root cause of performance issues
• Investigate inefficient queries running against a table
• Identify blocking sessions and deadlocks with DPA
• Find and investigate unusually long wait times (anomalies)
• About anomaly detection in DPA
• Add an annotation to document a change to the database