【多选题】You use the segment advisor to help determine objects for which space may be reclaimed. Which three statements are true about the advisor given by the segment advisor?()
A.
It may advise the use of online table redefinition for tables in dictionary managed tablespace.
B.
It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.
C.
It may advise the use of online table redefinition for tables in locally managed tablespaces
D.
It will detect and advise about chained rows.
E.
It may advise the use of segment shrink for free list managed tables.
【多选题】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 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.