When I run Segment Advisor, and I look at the advisor recommendations, I see for some of the tables the status Ignore even though the advisor does recommend perform shrink on the table. I have not been able to find an explanation for this in the documentation. Is there a reason why it would say Ignore, or can I go ahead and change it to accept or reviewed?
The first time you run the segment advisor, it says Not Reviewed for the status.
If you run it again without deleting the original results, it will put Ignore on the earlier run for those objects that were run before.
Toad for Oracle exposes what Oracle gives us.
Below is what Oracle states about dbms_advisor.mark_recommendation.
This procedure marks a recommendation for import or implementation.
Syntax
DBMS_ADVISOR.MARK_RECOMMENDATION (
task_name IN VARCHAR2
id IN NUMBER,
action IN VARCHAR2);
Parameters
Table 17-27 MARK_RECOMMENDATION Procedure Parameters
Parameter | Description |
|---|---|
| Name of the task. |
| The recommendation identifier number assigned by the Advisor. |
| The recommendation action setting. The possible actions are:
|
