单选题Automatic Shared Memory Management is disabled for your database instance. You realize that there arecases of SQL statements performing poorly because of repeated parsing activity， resulting in degradation ofperformance. What would be your next step t

题目内容(请给出正确答案)

单选题

Automatic Shared Memory Management is disabled for your database instance. You realize that there arecases of SQL statements performing poorly because of repeated parsing activity， resulting in degradation ofperformance. What would be your next step to improve performance（）

Run the SQL Access Advisor

Run the Memory Advisor for the sga.

Run the Memory Advisor for the pga.

Run the Memory Advisor for the shared pool.

Run the Memory Advisor for the buffer cache

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

更多相关问题

第1题

单选题You find that the execution time of reports in your datawarehouse application is significantly high. You suspect the lack of indexes to be the reason for the degradation in performance. Which advisory component would you refer to， in order to determine the appropriate indexes？（）AMemory AdvisorBSegment AdvisorCSQL Access AdvisorDAutomatic Workload Repository （AWR）EAutomatic Database Diagnostic Monitor （ADDM）

点击查看答案
第2题

单选题Automatic Shared Memory Management is disabled for your database instance. You realize that there arecases of SQL statements performing poorly because of repeated parsing activity， resulting in degradation ofperformance. What would be your next step to improve performance（）A Run the SQL Access AdvisorB Run the Memory Advisor for the sga.C Run the Memory Advisor for the pga.D Run the Memory Advisor for the shared pool.E Run the Memory Advisor for the buffer cache

点击查看答案
第3题

单选题Automatic Shared Memory Management （ASMM） has been enabled for your database instance. Theinitialization parameters for the components that are managed by ASMM are not set. After observing theeffects of ASSM， you executed the following command： SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M； Which statement is true in this scenario（）A The minimum memory size for the database buffer cache is set to 100 mb.B The maximum memory size that can be obtained by the database buffer cache during ASMM is set to100 mbC The minimum memory size allocated for a server process in the database buffer cache in dedicatedmode is set to 100 mb.D The maximum memory size from the database buffer cache that can be released for dynamicdistribution during ASMM is set to 100 mb

点击查看答案
第4题

单选题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.

点击查看答案
第5题

单选题For Oracle 11g， Oracle strongly recommends that you configure your database to use which of the following memory-management features？（）AAutomatic PGA Memory ManagementBAutomatic SGA Memory ManagementCAutomatic Shared Memory ManagementDAutomatic Memory ManagementEManual SGA Memory ManagementFNone of the above

点击查看答案
第6题

单选题You use the Memory Advisor to tune the memory structures of your database. What is the prerequisite to use the Memory Advisor？（）AThe database must be in the ARCHIVELOG mode.BThe automatic memory tuning must be enabled.CThe change tracking feature must be enabled.DThe automatic memory tuning must be disabled.

点击查看答案
第7题

单选题Your database is running on the automatic Program Global Area （PGA） memory management and Shared Memory Management mode. You want to increase the memory available for the SQL work areas. What would you do？（）Amodify the HASH_AREA_SIZE initialization parameterBmodify the PGA_AGGREGATE_TARGET initialization parameterCmodify the WORK_AREASIZE_POLICY initialization parameterDincrease the value of the SGA_TARGET initialization parameterEincrease the value of the SGA_MAX_SIZE initialization parameterFincrease the value of the SORT_AREA_SIZE initialization parameter

点击查看答案

单选题Automatic Shared Memory Management is disabled for your database instance. You realize that there arecases of SQL statements performing poorly because of repeated parsing activity， resulting in degradation ofperformance. What would be your next step t

题目内容(请给出正确答案)

更多相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容