LOG_BUFFER
DB_CACHE_SIZE
JAVA_POOL_SIZE
LARGE_POOL_SIZE
SHARED_POOL_SIZE
STREAMS_POOL_SIZE
第1题:
Which two statements are true regarding an Automatic Storage Management (ASM) instance? ()
第2题:
Which statement is true about the Manageability Monitor (MMON) background proces()
第3题:
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?()
第4题:
For Oracle 11g, Oracle strongly recommends that you configure your database to use which of the following memory-management features?()
第5题:
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?()
第6题:
Which background process does Automatic Shared Memory Management use to coordinate the sizing of memory components?()
第7题:
SORT_AREA SIZE and HASH_AREA_SIZE parameters are ignored in some of the user sessions. What could be the reason?()
第8题:
You use the Memory Advisor to tune the memory structures of your database. What is the prerequisite to use the Memory Advisor?()
第9题:
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?()
第10题:
You have configured Automatic Shared Memory Management. Which four memory structures would be automatically tuned? ()