Which two statements are true regarding the SQL Repair Advisor?

Which two statements are true regarding the SQL Repair Advisor? (Choose two.)

Which two statements are true regarding the SQL Repair Advisor? (Choose two.)

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.

Explanation:
You can run SQL Repair Advisor through the EM Support Workbench when an incident
raised.
Or You run the SQL Repair Advisor by creating and executing a diagnostic task using the
DBMS_SQLDIAG. CREATE_DIAGNOSIS_TASK and DBMS_SQLDIAG. respectively. The
SQL Repair Advisor first reproduces the critical error and then tries to produce a workaround
in the form of SQL patch.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Eamon

Eamon

OK, but answer a is not incorrect as you can run a …
DBMS_SQLDIAG.CREATE_DIAGNOSIS_TASK
with …
problem_type =>PROBLEM_TYPE_PERFORMANCE