多项选择题
A.The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.
B.The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.
C.Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA memory management.
D.The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA memory management mode.
单项选择题 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?()
单项选择题 InyourproductiondatabaseyouwanttouseanAutomaticStorageManagement(ASM)instancetomanagethedatabasefiles.Whichoptionwouldyouusetomigratethedatabasefilesfromanon-ASMinstancetoanASMinstance?()