To manually configure the SGA components using Oracle Enterprise Manager Memory Advisor, you can set values for which of the following initialization parameters?()
A DB_CACHE_SIZE
B SHARED_POOL_SIZE
C LARGE_POOL_SIZE
D JAVA_POOL_SIZE
E SGA_MAX_SIZE
F SORT_AREA_SIZE
正确答案
答案解析
相似试题
(多选题)
Automatic PGA Memory Management eliminates the need to manually configure which of the following initialization parameters?()
(单选题)
To view the results of a manual SQL Tuning Advisor task, which steps should the DBA take?()
(多选题)
Using Oracle Enterprise Manager to set SGA pool values manually, for which of the following pools does Oracle EM offer advice to set the value appropriately?()
(单选题)
You are attempting to clear an unarchived redo log file. In order to manually enact a log switch, which of the following statements is appropriate?()
(单选题)
When an UNDO segment is created manually by you, its availability status is set to which of the following automatically by Oracle?()
(单选题)
In which situation are you NOT required to perform an incomplete recovery?()
(单选题)
Which background process reads the redo log buffer and writes it to a file?()
(单选题)
Performance divergence indicated in the Workload Replay report is most likely due to what?()
(单选题)
Which statement must you issue to an already-running Automatic Storage Management (ASM) instance to prevent database instances from connecting to the ASM instance?()