I am using Oracle 11.2.0.3.
I want to manually execute recommendations of segment advisor. When I query TABLE (DBMS_SPACE.asa_recommendations , I see there are column c1, c2, and c3 with actual sql. Do I need to execute SQL in all of these columns (c1,c2,c3) and in which order should they be executed?
Example:
SELECT RECOMMENDATIONS, c1, c2, c3 FROM TABLE (DBMS_SPACE.asa_recommendations ());
Returns:
Recommendation: Enable row movement of the table HR.EMP and perform shrink, estimated savings is 43925231 bytes.
C1 : alter table "HR"."EMP" shrink space
C2: alter table "HR"."EMP" shrink space COMPACT
C3: alter table "HR"."EMP" enable row movement