SQL Repair Advisor

(Choose two.)which two statements are true regarding the sql repair advisor?
A. The SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements.
B. The SQL Repair Advisor can beinvoked evenwhen即使當 the incident isnot active for a SQL statement crash. Sql修復建議器可以被呼叫，即使當事件不是活動的。
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 RepairAdvisor when he or she receives an alert generated when a SQL statement crashesand an incident is created in the ADR. DBA可以呼叫sql修復建議器（當他或她接受到一個告警），當一個sql語句崩潰和一個事件建立在ADR中時。


As a DBA or a developer of SQL code you probably know that SQL statements can be maddeningly frustrating to write. just getting the WHERE clause just right can be a time-consuming process requiring monumental effort. Frustration really comes when you encounter errors when running SQL that you know should work. These errors can be in the form of ORA-0600 or ORA-7445 or other ORA types of errors.


In Oracle 11g Oracle offers the SQL Repair Advisor to try to reduce the impact of Oracle product related errors when you are writing SQL code. When you have a SQL statement that returns some error you can instruct the SQL Repair Advisor to analyze the statement and provide recommendations on how to correct the problem. Recommendations can sometimes be in the form of a patch set to be applied or an alternative way to write the SQL.


The SQL Repair Advisor is run from the Oracle Support Workbench. Each time an ORA-600 occurs, that failure will be recorded in the Support Workbench. You can then select the problem that is associated with your SQL statement and then from the Problem Details page choose to start the SQL Repair Advisor. Once the SQL Repair Advisor has completed it's task, you will be provided options. These options typically will include a suggested recommendation and provide you with the ability to implement that recommendation.

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29196873/viewspace-1098015/，如需轉載，請註明出處，否則將追究法律責任。