Oracle OCP 1Z0 053 Q258(SQL Repair Advisor)
258.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.
Answer: BD
Health Monitor并不能调用SQL Repair Advisor
About the SQL Repair Advisor
参考：http://blog.csdn.net/jgmydsai/article/details/38665779
http://docs.oracle.com/cd/E11882_01/server.112/e25494/diag.htm#ADMIN12301
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.
Answer: BD
Health Monitor并不能调用SQL Repair Advisor
About the SQL Repair Advisor
You run the SQL Repair Advisor after a SQL statement fails with a critical error. The advisor analyzes the statement and in many cases recommends a patch to repair the statement. If you implement the recommendation, the applied SQL patch circumvents the failure by causing the query optimizer to choose an alternate execution plan for future executions.
参考：http://blog.csdn.net/jgmydsai/article/details/38665779
http://docs.oracle.com/cd/E11882_01/server.112/e25494/diag.htm#ADMIN12301
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/8520577/viewspace-2073066/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
