单选题When tuning Automatic PGA Memory Management， which of the following views will provide the information specified？（）AThe V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase PGA_AGGREGATE_TARGETBThe V$PGA_TARGET_ADVIC

题目

单选题

When tuning Automatic PGA Memory Management， which of the following views will provide the information specified？（）

The V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase PGA_AGGREGATE_TARGET

The V$PGA_TARGET_ADVICE view shows how the V$SQL_WORKAREA histogram will change if you change the value of PGA_AGGREGATE_TARGET

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

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

更多“When tuning Automatic PGA Memory Management， which of the fo”相关问题

第1题

Which background process does Automatic Shared Memory Management use to coordinate the sizing of memory components？（）A、PMONB、SMONC、MMNLD、MMANE、MMON

点击查看答案
第2题

Which statement is true about the Manageability Monitor （MMON） background proces（）A、It transfers statistics from memory to disk at regular intervals.B、It coordinates the rebalance activity for disk groups when ASM is used.C、It communicates with the Automatic Storage Management （ASM） instance on behalf of the databaseinstance.D、It performs dynamic memory management when Automatic Shared Memory Management is enabledfor the database instance.

点击查看答案
第3题

For Oracle 11g， Oracle strongly recommends that you configure your database to use which of the following memory-management features？（） A、 Automatic PGA Memory ManagementB、 Automatic SGA Memory ManagementC、 Automatic Shared Memory ManagementD、 Automatic Memory ManagementE、 Manual SGA Memory ManagementF、 None of the above

点击查看答案
第4题

Which of the following Oracle features is enabled by setting a nonzero value for the MEMORY_TARGET initialization parameter？（） A、 Automatic PGA Memory ManagementB、 Automatic SGA Memory ManagementC、 Automatic Shared Memory ManagementD、 Automatic Memory ManagementE、 Manual SGA Memory ManagementF、 None of the above

点击查看答案
第5题

In Oracle 11g，by default which one of the following conditions implicitly enables Automatic PGA Memory Management？（） A、 Setting a nonzero value for SGA_TARGETB、 Configuring Automatic Shared Memory ManagementC、 Configuring Automatic Memory ManagementD、 Setting a nonzero value for SGA_MAX_SIZE and PGA_AGGREGATE_TARGETE、 None of the above

点击查看答案
第6题

By setting the value of MEMORY_TARGET to zero and setting the value of SGA_TARGET to a nonzero value， you will enable which of the following memory-management options？（） A、 Automatic PGA Memory ManagementB、 Automatic SGA Memory ManagementC、 Automatic Shared Memory ManagementD、 Automatic Memory ManagementE、 Manual SGA Memory ManagementF、 None of the above

点击查看答案
第7题

单选题Which background process does Automatic Shared Memory Management use to coordinate the sizing of memory components？（）A PMONB SMONC MMNLD MMANE MMON

点击查看答案

1Z0-053

单选题When tuning Automatic PGA Memory Management， which of the following views will provide the information specified？（）AThe V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase PGA_AGGREGATE_TARGETBThe V$PGA_TARGET_ADVIC

题目

更多“When tuning Automatic PGA Memory Management， which of the fo”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容