The following parameters are set for your Oracle 12c database instance:
OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE
OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE
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_EVOVLE_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, 4, 5
B.
2, 1, 4, 3, 5
C.
1, 2, 3, 4, 5
D.
1, 2, 4, 5
https://docs.oracle.com/database/121/TGSQL/tgsql_spm.htm#TGSQL658
There is no correct answer according to oracle doc…
Should be : 2 4 5 3
The 1 step isnt necessary according to this
https://docs.oracle.com/database/121/ARPLS/d_spm.htm#ARPLS68154
CREATE_EVOLVE_TASK Function
Creates an advisor task and sets its parameters
Most probable would be A I guess
A is the right answer, as I stated before in my previous awaiting moderation comment.
http://www.oracle.com/technetwork/database/bi-datawarehousing/twp-sql-plan-mgmt-12c-1963237.pdf
Page 12/13
The correct answer is B.
https://docs.oracle.com/database/121/TGSQL/tgsql_spm.htm#TGSQL94651 described under “Evolving SQL Plan Baselines Manually”
Probably you are right.
But if you see the procedures described below they say to report the task before implementing it.
And In the link I provided in page 12/13 is this
Manual Plan Evolution
Alternatively, it is possible to evolve an unaccepted plan manually using Oracle Enterprise Manager or
the supplied package DBMS_SPM. From Oracle Database 12c onwards, the original SPM evolve function
(DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE) has been deprecated in favor of a new API that calls the
SPM evolve advisor. Figure 9 shows the steps needed to invoke the SPM evolve advisor. It is typically
a three step processes beginning with the creation of an evolve task. Each task is given a unique name,
which enables it to be executed multiple times. Once the task has been executed, you can review the
evolve report by supplying the TASK_ID and EXEC_ID to the DBMS_SPM.REPORT_EVOLVE_TASK
function.
Weird.
B it should be. But it’s very unlogical to accept a implementation withut first reviewing it. And Oracle documentation appears to contradict themselves in these two documents.
which one is correct?
B
They’re pretty certain on the messages for Q.27 on the 1Z0-060 messages too.
http://www.aiotestking.com/oracle/identify-the-correct-sequence-of-steps-7/
Thanks steve and everyone
B
I have no ideas. Just try to learn by heart for this question 🙂
B. Here docs:
1. Create an evolve task
2. Optionally, set evolve task parameters
3. Execute the evolve task
4. Implement the recommendations in the task
5. Report on the task outcome
https://docs.oracle.com/database/121/TGSQL/tgsql_spm.htm#TGSQL94653
New question
Examine these parameters that are set for your Oracle 12c database instance:
OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE
OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE
Examine these steps:
1. Set the evolve task parameters.
2. Create the evolve task by using the DBMS_SPM.CREATE_EVOVLE_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 MINIMUN number of steps in the correct order to manually evolve SQL plans.
A. 2, 4, 5
B. 2, 1, 4, 3, 5
C. 1, 2, 3, 4, 5
D. 1, 2, 4, 5
A is correct
B