单项选择题
A.modify the HASH_AREA_SIZE initialization parameter
B.modify the PGA_AGGREGATE_TARGET initialization parameter
C.modify the WORK_AREASIZE_POLICY initialization parameter
D.increase the value of the SGA_TARGET initialization parameter
E.increase the value of the SGA_MAX_SIZE initialization parameter
F.increase the value of the SORT_AREA_SIZE initialization parameter
多项选择题 You are working in a dedicated server environment. Your database is running in the automatic Program Global Area (PGA) memory management mode. Which two statements are correct in this scenario?()
单项选择题 Yourdatabaseisusingsharedserverconfiguration.WhichoptionalmemorystructurewouldyouconfiguretostoretheUserGlobalArea(UGA)informationandimprovethesharedpoolperformance?()
单项选择题 In your running instance, some of the initialization parameters are set as shown below: SGA_MAX_SIZE = 14GB DB_CACHE_SIZE = 1GB SHARED_POOL_SIZE = 3GB STATISTICS_LEVEL = BASIC PGA_AGGREGATE_TARGET = 0 You plan to enable Automatic Shared Memory Management but you are not able to set SGA_TARGET to a nonzero value. What could be the reason?()