单项选择题

A. java poolB. shared poolC. buffer cacheD. program glo……

You recently added a third-party application to your database and do not have access to the SQL code of this application. Database users are complaining of performance-related issues， such as increased time required to complete a query. While investigating， you discover from the STATSPACK utility that some of the memory structures have low hit ratios. You plan to resize some of the memory structures by using the Memory Advisor. For which memory structure will you fail to obtain optimal settings by using the Memory Advisor？（）

A. java pool
B. shared pool
C. buffer cache
D. program global area

<上一题目录下一题>

热门试题

多项选择题YouareenablingtheAutomaticSharedMemoryManagementfeatureintheOracleDatabase10gtoensurethattheimportantmemorystructuresoftheSystemGlobalArea（SGA）areautomaticallyadjusteddependingonthedatabaseworkload.YouareusingEnterpriseManager10gtoenablethisfeature.YouarecurrentlyontheAdministrationtabpage. WhichtwolinksshouldyouclicktogototheMemoryAdvisorpage？（）

A. Advisor Central
B. Global Attributes
C. Resource Monitors
D. Memory Parameters
E. Database Usage Statistics
F. All Initialization Parameters
G. Automatic Workload Repository

单项选择题You have included the following parameter setting in your server parameter file： PGA_AGGREGATE_TARGET = 800M SORT_AREA_SIZE = 100M HASH_AREA_SIZE = 100M BITMAP_MERGE_AREA_SIZE = 100M CREATE_BITMAP_AREA_SIZE = 100M Which statement is true？（）

A. All the *_AREA_SIZE parameters are ignored.
B. The Automatic PGA Memory Management feature cannot be disabled.
C. The total Program Global Area （PGA） memory cannot be manually increased above 800M.
D. The total memory for the PGA can automatically exceed 800M using the Automatic PGA Memory Management feature.

单项选择题You have included the following parameter settings in your SPFILE： SGA_MAX_SIZE=8G SGA_TARGET=6G DB_CACHE_SIZE=2G SHARED_POOL_SIZE=1G LOG_BUFFER=64M DB_KEEP_CACHE_SIZE=960M Which statement is true if you modify the SGA_TARGET initialization parameter？（）

A.The SGA_TARGET initialization parameter cannot be set to a value greater than 8G
B. The DB_CACHE_SIZE initialization parameter cannot be set to a value less than 2G
C. The DB_CACHE_SIZE initialization parameter cannot be set to a value greater than 2G
D. The DB_KEEP_CACHE_SIZE initialization parameter cannot be set to a value greater than 960M
E. The DB_KEEP_CACHE_SIZE initialization parameter cannot be set to a value less than 960M

多项选择题You are configuring the PROD database to use an internal tuning algorithm to monitor the performance of the workload. To achieve this configuration， you specify the following parameter settings in the SPFILE： SGA_TARGET = 512M SHARED_POOL_SIZE = 256M Which two statements are true when modifying the SHARED_POOL_SIZE initialization parameter in the SPFILE？（）

A. Modifying the SHARED_POOL_SIZE initialization parameter cannot be accomplished if the SGA_TARGET initialization parameter is set to a non-zero value.
B. Modifying the value of the SHARED_POOL_SIZE initialization parameter to zero is not allowed if the SGA_TARGET initialization parameter is set to a nonzero value.
C. Increasing the value of the SHARED_POOL_SIZE initialization parameter does not increase the shared pool component size. It sets the lower limit for the size of this component.
D. Decreasing the value of the SHARED_POOL_SIZE initialization parameter does not reduce the size of the shared pool component immediately. It sets the lower limit for the size of this component.
E. Increasing the value of the SHARED_POOL_SIZE initialization parameter immediately increases the shared pool component to the desired size by reallocating the additional memory from the auto-tuned memory components.
F. Decreasing the value of the SHARED_POOL_SIZE initialization parameter immediately shrinks the shared pool component to the desired size while reallocating the released memory to the memory components that are not auto-tuned.

单项选择题You are upgrading to the Oracle 10g Database and will use the Automatic Shared Memory Management feature of the Oracle 10g Database. Which background process serves as the SGA memory broker that coordinates the sizing of the memory components？（）

A. MMAN
B. PMON
C. MMON
D. MMNL