OCP-1Z0-053-V12.02-421题
来源:互联网 发布:js.com 编辑:程序博客网 时间:2024/05/01 06:46
421.When tuning Automatic PGA Memory Management, which of the following views will provide the information specified?
A. The V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase PGA_AGGREGATE_TARGET.
B. The V$PGA_TARGET_ADVICE view shows how the V$SQL_WORKAREA histogram will change if you change the value of PGA_AGGREGATE_TARGET.
C. The V$PGA_TARGET_ADVICE_HISTOGRAM view shows how the V$SQL_WORKAREA_HISTOGRAM will change if you switch between Manual and Automatic PGA Memory Management.
D. The V$PGA_TARGET_ADVICE view shows how performance will improve for the different work areas if you switch from Manual to Automatic PGA Memory Management.
Answer: A
答案解析:
V$PGA_TARGET_ADVICE
predicts how the cache hit percentage and over allocation count statistics displayed by the V$PGASTAT
performance view would be impacted if the value of the PGA_AGGREGATE_TARGET
parameter is changed. The prediction is performed for various values of the PGA_AGGREGATE_TARGET
parameter, selected around its current value. The advice statistic is generated by simulating the past workload run by the instance.
The content of the view is empty if PGA_AGGREGATE_TARGET
is not set. In addition, the content of this view is not updated if the STATISTICS_LEVEL
parameter is set to BASIC
. Base statistics for this view are reset at instance startup and when the value of the PGA_AGGREGATE_TARGET
initialization parameter is dynamically modified.
- OCP-1Z0-053-V12.02-421题
- OCP-1Z0-053-V12.02-679题
- OCP-1Z0-053-V12.02-591题
- OCP-1Z0-053-V12.02-590题
- OCP-1Z0-053-V12.02-552题
- OCP-1Z0-053-V12.02-551题
- OCP-1Z0-053-V12.02-549题
- OCP-1Z0-053-V12.02-548题
- OCP-1Z0-053-V12.02-234题
- OCP-1Z0-053-V12.02-584题
- OCP-1Z0-053-V12.02-595题
- OCP-1Z0-053-V12.02-184题
- OCP-1Z0-053-V12.02-59题
- OCP-1Z0-053-V12.02-676题
- OCP-1Z0-053-V12.02-667题
- OCP-1Z0-053-V12.02-660题
- OCP-1Z0-053-V12.02-580题
- OCP-1Z0-053-V12.02-323题
- android 开发 adb devices 找不到设置问题
- union数据结构的巧用-判断机器字节序
- 第一篇CSDN博客 installshield 去掉修复完成之后弹出的维修完成对话框
- 单板重启后,cinder-volume服务起不来
- 数据库连接池的原理
- OCP-1Z0-053-V12.02-421题
- shell编程范例之字符串操作
- asp.net中用JavaScript调用后台C#函数
- 在Android中查看和管理sqlite数据库
- hdu2588欧拉函数
- XModem协议
- linux进程(二)进程创建与调度
- ORCAD CAPTURE元件库介绍
- 多线程中的资源释放