The following parameter are set for your Oracle 12c database instance: You want to
manage the SQL plan evolution task manually. Examine the following steps: 1. Set the
evolve task parameters. 2. Create the evolve task by using the
DBMS_SPM.CREATE_EVOLVE_TASK function. 3. Implement the recommendations in the
task by using the DBMS_SPM.IMPLEMENT_EVOLVE_TASK function. 4. Execute the
evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function. 5. Report the
task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function. Identify the
correct sequence of steps:
A.
2, 1, 4, 3, 5
B.
1, 2, 3, 4, 5
C.
1, 2, 4, 5
D.
2, 4, 5
Explanation:
A
A:
https://docs.oracle.com/database/121/TGSQL/tgsql_spm.htm#TGSQL94653