网友您好, 请在下方输入框内输入要搜索的题目:
YousetthevalueoftheSGA_TARGETinitializationparameterto1GtoenableOracletoautomaticallyresizemostofthememorycomponentsaccordingtothecurrentworkloadinthedatabase.Youissuethefollowingstatement:SQL>SELECTname,value,isdefault2FROMv$parameter3WHEREnameLIKE’%size%’;TheoutputofthisstatementdisplaysthattheDB_CACHE_SIZE,SHARED_POOL_SIZE,LARGE_POOL_SIZE,andJAVA_POOL_SIZEinitializationparameterscontainazerovalue.Whatdoesthisimply?()
A.TheSGA_TARGETinitializationparametercannotbesettoavaluelessthan1G
B.TheSGA_TARGETinitializationparametercannotbesettoavaluegreaterthan1G
C.TheMemoryAdvisoroftheOracleEnterpriseManager10gcannotbeusedtoobtainadviceontheimportantmemorycomponentsoftheSGA
D.ThevaluesoftheDB_CACHE_SIZE,SHARED_POOL_SIZE,LARGE_POOL_SIZE,andJAVA_POOL_SIZEinitializationparameterscannotbesetmanually.
E.NominimumlimitsareimposedontheDB_CACHE_SIZE,SHARED_POOL_SIZE,LARGE_POOL_SIZE,andJAVA_POOL_SIZEinitializationparameters.
F.TheAutomaticSharedMemoryManagementfeaturecannotbedisabledunlessyouspecifyvaluesfortheDB_CACHE_SIZE,SHARED_POOL_SIZE,LARGE_POOL_SIZE,andJAVA_POOL_SIZEinitializationparametersintheinitializationparameterfile.
参考答案