A. The SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements.
B. The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash.
C. The SQL Repair Advisor is invoked by the Health Monitor when it encounters the problematic SQL statement.
D. The DBA can invoke the SQL Repair Advisor when he or she receives an alert generated when a SQL statement crashes and an incident is created in the ADR.
答案：（B、D）
解析：
《Administrator's Guide》 9.8
可以在SQL语句因为严重的错误而失败之后运行SQL Repair Advisor.
这个指导会分析这个语句并且在许多情况下会建议一个patch来修复这个语句.
如果你实现了这些建议,则应用的SQL patch会绕过这个失败（通过使优化器为后面的执行选择替代的优化器)