Oracle OCP 1Z0 053 Q246(SQL Plan Baselines)
plan for a SQL statement but does not find a matching plan in the SQL plan baseline.
Which two operations are performed by the optimizer in this scenario? (Choose two.)
A. The optimizer adds the new plan to the plan history.
B. The optimizer selects the new plan for the execution of the SQL statement.
C. The optimizer adds the new plan to the SQL plan baseline as an accepted plan.
D. The optimizer adds the new plan to the SQL plan baseline but not in the ENABLED state.
E. The optimizer costs each of the accepted plans in the SQL plan baseline and picks the one with the
lowest cost.
Answer: AE
參考:http://blog.csdn.net/jgmydsai/article/details/38555635
http://docs.oracle.com/cd/E11882_01/server.112/e41573/optplanmgmt.htm#PFGRF95115
15.2.2 Selecting SQL Plan Baselines
During the SQL plan baseline selection phase, Oracle Database detects plan changes based on the stored plan history, and selects plans to avoid potential performance regressions for a set of SQL statements.
Each time the database compiles a SQL statement, the optimizer does the following:
-
Uses a cost-based search method to build a best-cost plan
-
Tries to find a matching plan in the SQL plan baseline
-
Does either of the following depending on whether a match is found:
-
If found, then the optimizer proceeds using the matched plan
-
If not found, then the optimizer evaluates the cost of each accepted plan in the SQL plan baseline and selects the plan with the lowest cost
-
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/8520577/viewspace-2075535/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle OCP IZ0-053 Q478(SQL Plan Baselines)OracleSQL
- Oracle OCP 1Z0 053 Q437(Resource Plan)Oracle
- sql plan baselines(一)SQL
- Manage SQL Plan Baselines in Oracle 12cSQLOracle
- Oracle OCP 1Z0 053 Q493(SQL Performance Analyzer)OracleSQLORM
- SQL Plan Baselines 實驗01SQL
- Oracle OCP 1Z0 053 Q201(DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE)OracleSQL
- Oracle OCP 1Z0 053 Q258(SQL Repair Advisor)OracleSQLAI
- Oracle OCP 1Z0 053 Q650Oracle
- Oracle OCP 1Z0 053 Q324Oracle
- Oracle OCP 1Z0 053 Q27Oracle
- Oracle OCP 1Z0 053 Q49Oracle
- Oracle OCP 1Z0 053 Q10Oracle
- Oracle OCP 1Z0 053 Q685Oracle
- Oracle OCP 1Z0 053 Q454Oracle
- Oracle OCP 1Z0 053 Q500Oracle
- Oracle OCP 1Z0-053 Q252(SQL Plan Baseline)OracleSQL
- Manually Evolve and Accept SQL PLAN BASELINES in Oracle 12cSQLOracle
- Oracle OCP 1Z0 053 Q253(SQL Tuning Advisor)OracleSQL
- Oracle OCP 1Z0 053 Q444(Scheduler)Oracle
- Oracle OCP 1Z0 053 Q440(Scheduler)Oracle
- Oracle OCP 1Z0 053 Q601Oracle
- Oracle OCP 1Z0 053 Q472(Locale)Oracle
- Oracle OCP 1Z0 053 Q525(ASM)OracleASM
- Oracle OCP 1Z0 053 Q292(NFS)OracleNFS
- Oracle OCP 1Z0 053 Q538(ASM)OracleASM
- Oracle OCP 1Z0 053 Q416Oracle
- Oracle OCP 1Z0 053 Q648(Flashback)Oracle
- Oracle OCP 1Z0 053 Q520Oracle
- Oracle OCP 1Z0 053 Q607Oracle
- Oracle OCP 1Z0 053 Q500(Rman)Oracle
- Oracle OCP 1Z0 053 Q707Oracle
- Oracle OCP 1Z0 053 Q28(INCREMENTAL)OracleREM
- Oracle OCP 1Z0 053 Q332Oracle
- Oracle OCP 1Z0 053 Q269Oracle
- Oracle OCP 1Z0 053 Q406(sql tuning advisor)OracleSQL
- Oracle OCP 1Z0 053 Q123(SQL Access Advisor)OracleSQL
- Oracle OCP 1Z0 053 Q83(Flashback Database)OracleDatabase