试题详情
- 单项选择题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
- A
关注下方微信公众号，在线模考后查看
热门试题
- Which two̳
- Which of
- Examine the&en
- An existing master-
- （）参数用于确定是否要导入整个导出文件。
- Which statemen
- 假定以手动方式管理数据块，PCTFREE
- View the E
- You have 100 segment
- Review the definiti
- Which two statements
- Which statemen
- An online tablespace
- Exhibit： Using&
- Which of
- Youneedtoproducearep
- You lost
- Automatic Shar
- Which clause should
- Given: Whatistheres