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> ALT

题目

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 mb
C、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

更多“Automatic Shared Memo”相关问题

第1题

Which two initialization parameters would you set to enable Automatic Shared Memory Management？（）A、 set SHARED_POOL_SIZE to zeroB、 set STATISTICS_LEVEL to BASICC、 set SGA_TARGET to a non-zero valueD、 set DB_CACHE_SIZE to a non-zero valueE、 set STATISTICS_LEVEL to TYPICAL or ALL

点击查看答案
第2题

SORT_AREA SIZE and HASH_AREA_SIZE parameters are ignored in some of the user sessions. What could be the reason？（）A、The User Global Area （UGA） is not configured.B、The sessions were started using the login name SYS.C、The sessions are running in the Automatic Shared Memory Management mode.D、The sessions are running in the automatic Program Global Area （PGA） memory management mode.

点击查看答案
第3题

You are enabling the Automatic Shared Memory Management feature in the Oracle Database 10g to ensure that the important memory structures of the System Global Area （SGA） are automatically adjusted depending on the database workload. You are using Enterprise Manager 10g to enable this feature. You are currently on the Administration tab page. Which two links should you click to go to the Memory Advisor page？（） A、 Advisor CentralB、 Global AttributesC、 Resource MonitorsD、 Memory ParametersE、 Database Usage StatisticsF、 All Initialization ParametersG、 Automatic Workload Repository

点击查看答案
第4题

A senior DBA asked you to execute the following command to improve performance: SQL> ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle); You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows. What could be a reason for this recommendation?（）A、The keep pool is not configured.B、Automatic Workarea Management is not configured.C、Automatic Shared Memory Management is not enabled.D、The data blocks in the SUBSCRIBE_LOG table are rarely accessed.E、All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view

点击查看答案
第5题

The Automatic Shared Memory Management feature is enabled for the PROD database. Currently， a lot of insert activity is taking place in the database， and the memory structures are allocated according to the database workload. As the workload reduces， you decide to perform batch jobs in the database. Which of the following initialization parameters are NOT automatically resized according to the new workload and continue to remain unchanged？（）A、 LOG_BUFFERB、 DB_CACHE_SIZEC、 JAVA_POOL_SIZED、 LARGE_POOL_SIZEE、 SHARED_POOL_SIZEF、 STREAMS_POOL_SIZE

点击查看答案
第6题

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

点击查看答案
第7题

You have configured Automatic Shared Memory Management. Which four memory structures would be automatically tuned？（）A、 log bufferB、 Java poolC、 Large poolD、 Fixed SGAE、 Shared poolF、 Streams poolG、 Keep buffer cacheH、 Database buffer cache

点击查看答案

Automatic Shared Memo

题目

更多“Automatic Shared Memo”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容