053第478题
来源:互联网 发布:铝合金方管承重数据 编辑:程序博客网 时间:2024/06/03 22:01
478.Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines.
(Choose two.)
A. Cursor cache
B. Stored outline
C. SQL Tuning Set
D. Automatic Workload Repository (AWR) snapshots
Answer: AC
You can evolve an existing SQL plan baseline by manually loading plans from the shared SQL area or from a SQL tuning set. When you manually load plans into a SQL plan baseline, the database adds these loaded plans as accepted plans
15.2.1.2.1 Loading Plans from SQL Tuning Sets and AWR Snapshots
To load plans from a SQL tuning set, use the LOAD_PLANS_FROM_SQLSET
function of the DBMS_SPM
package. The following example loads the plans stored in the SQL tuning set named tset1
:
DECLARE my_plans PLS_INTEGER;BEGIN my_plans := DBMS_SPM.LOAD_PLANS_FROM_SQLSET( sqlset_name => 'tset1');END;/
To load plans from Automatic Workload Repository (AWR), load the plans stored in AWR snapshots into a SQL tuning set before using theLOAD_PLANS_FROM_SQLSET
function as described in this section.
15.2.1.2.2 Loading Plans from the Shared SQL Area
To load plans from the shared SQL area, use the LOAD_PLANS_FROM_CURSOR_CACHE
function of the DBMS_SPM
package. In the following example, Oracle Database loads the plans located in the shared SQL area for the SQL statement identified by its sql_id
:
DECLARE my_plans PLS_INTEGER;BEGIN my_plans := DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE( sql_id => '99twu5t2dn5xd');END;/
- 053第478题
- 053第471题
- 053第85题
- 053第170题
- 053第386题
- 053第246题
- 053第521题
- 053第495题
- 053第425题
- 053第383题
- 053 第561题
- 053第423题
- 053 第500题
- 053第455题
- 053第244题
- 053第449题
- 053第279题
- 053第256题
- 3Sum Closest
- 观察者模式 - 行为模式
- jsp-DB
- 数位dp题集
- Android多媒体:AudioSystem,AudioService和AudioManager
- 053第478题
- DirectX11 图形流水线历史以及着色器简介
- for in 遍历数组或对象注意事项
- CentOS 6.3+Python 2.7.10安装pycurl遇到的问题汇总
- linux系统下struct大小的计算总结
- Strategy模式
- 畅通工程续
- 黑马程序员——高新技术---反射
- Verilog实现m序列发生器