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_BUFFER
B DB_CACHE_SIZE
C JAVA_POOL_SIZE
D LARGE_POOL_SIZE
E SHARED_POOL_SIZE
F STREAMS_POOL_SIZE
正确答案
答案解析
相似试题
(多选题)
Which two statements are true about the Automatic Diagnostic Repository (ADR)?()
(多选题)
Which two statements are true about the Automatic Workload Repository (AWR)()
(单选题)
Automatic data conversion will occur if which of the following happens?()
(多选题)
Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)()
(多选题)
Identify the activities performed as part of the Automatic SQL Tuning process in the maintenance window?()
(多选题)
Automatic PGA Memory Management eliminates the need to manually configure which of the following initialization parameters?()
(单选题)
Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework?()
(单选题)
When tuning Automatic PGA Memory Management, which of the following views will provide the information specified?()
(单选题)
Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework? ()
(单选题)
Which statement is true regarding the retention policy for the incidents accumulated in the Automatic Diagnostic Repository (ADR)?()