OCP 1Z0 053 35
来源:互联网 发布:vm mac 硬件加速 编辑:程序博客网 时间:2024/06/05 20:08
SQL profiles automatically. Which action would you perform to achieve this?
A. Edit the automatic maintenance window group configuration.
B. Set the CURSOR_SHARING parameter to EXACT for the database instance.
C. Use the DBMS_SQLTUNE.SET_TUNING_TASK_PARAMETERS procedure to set
ACCEPT_SQL_PROFILES to FALSE.
D. Set the SQLTUNE_CATEGORY parameter to DEFAULT for the database instance.
Answer: C
Tests SQL profiles by executing the SQL statement
If a SQL profile is recommended, the database tests the new profile by executing the SQL statement both with and without the profile. If the performance improvement improves at least threefold, then the database accepts the SQL profile, but only if the ACCEPT_SQL_PROFILES
task parameter is set to TRUE
. Otherwise, the automatic SQL tuning reports merely report the recommendation to create a SQL profile.
You can alter attributes of an existing SQL profile with the ALTER_SQL_PROFILE
procedure. Modifiable attributes are STATUS
, NAME
, DESCRIPTION
, and CATEGORY
.
The CATEGORY
attribute determines which sessions can apply a profile. You can view the CATEGORY
attribute by querying DBA_SQL_PROFILES.CATEGORY
. By default, all profiles are in the DEFAULT
category, which means that all sessions in which the SQLTUNE_CATEGORY
initialization parameter is set to DEFAULT
can use the profile.
By altering the categoryof a SQL profile, you can determine which sessions are affected by profile creation. For example, by setting thecategory to DEV
, only sessions in which the SQLTUNE_CATEGORY
initialization parameter is set to DEV
can use the profile. Other sessions do not have access to the SQL profile and execution plans for SQL statements are not impacted by the SQL profile. This technique enables you to test a profile in a restricted environment before making it available to other sessions.
- OCP 1Z0 053 35
- OCP 1Z0 053 1
- OCP 1Z0 053 2
- OCP 1Z0 053 3
- OCP 1Z0 053 4
- OCP 1Z0 053 5
- OCP 1Z0 053 6
- OCP 1Z0 053 7
- OCP 1Z0 053 8
- OCP 1Z0 053 9
- OCP 1Z0 053 10
- OCP 1Z0 053 11
- OCP 1Z0 053 12
- OCP 1Z0 053 13
- OCP 1Z0 053 14
- OCP 1Z0 053 15
- OCP 1Z0 053 16
- OCP 1Z0 053 17
- Mac OS X 获取Root权限代码
- The program can't start because libgcc_s_dw2-1.dll is missing
- centos 5.6下Ganglia监控安装及部署
- 产品经理必知:竞品分析,你懂了吗?
- servlet调用spring中的bean(注解方式)
- OCP 1Z0 053 35
- 数字签名和数字加密的工作流程与比较
- 黑马程序员-Runtime对象
- wxConfig类学习
- 上海网页平面UI-4期班就业最新信息---毕业才一周,已有15人就业
- Apache 403 error, (13)Permission denied: access to / denied问题
- MyEclipse 修改代码不生效
- 红黑树上的连接操作
- shell编程gcc命令