MME Pool的主要特性是什么?
MME Pool的主要特性是什么?
相关考题：
YouareconfiguringthePRODdatabasetouseaninternaltuningalgorithmtomonitortheperformanceoftheworkload.Toachievethisconfiguration，youspecifythefollowingparametersettingsintheSPFILE：SGA_TARGET=512MSHARED_POOL_SIZE=256MWhichtwostatementsaretruewhenmodifyingtheSHARED_POOL_SIZEinitializationparameterintheSPFILE？（）A.ModifyingtheSHARED_POOL_SIZEinitializationparametercannotbeaccomplishediftheSGA_TARGETinitializationparameterissettoanon-zerovalue.B.ModifyingthevalueoftheSHARED_POOL_SIZEinitializationparametertozeroisnotallowediftheSGA_TARGETinitializationparameterissettoanonzerovalue.C.IncreasingthevalueoftheSHARED_POOL_SIZEinitializationparameterdoesnotincreasethesharedpoolcomponentsize.Itsetsthelowerlimitforthesizeofthiscomponent.D.DecreasingthevalueoftheSHARED_POOL_SIZEinitializationparameterdoesnotreducethesizeofthesharedpoolcomponentimmediately.Itsetsthelowerlimitforthesizeofthiscomponent.E.IncreasingthevalueoftheSHARED_POOL_SIZEinitializationparameterimmediatelyincreasesthesharedpoolcomponenttothedesiredsizebyreallocatingtheadditionalmemoryfromtheauto-tunedmemorycomponents.F.DecreasingthevalueoftheSHARED_POOL_SIZEinitializationparameterimmediatelyshrinksthesharedpoolcomponenttothedesiredsizewhilereallocatingthereleasedmemorytothememorycomponentsthatarenotauto-tuned.
YousetthevalueoftheSGA_TARGETinitializationparameterto1GtoenableOracletoautomaticallyresizemostofthememorycomponentsaccordingtothecurrentworkloadinthedatabase.Youissuethefollowingstatement：SQLSELECTname，value，isdefault2FROMv$parameter3WHEREnameLIKE’%size%’；TheoutputofthisstatementdisplaysthattheDB_CACHE_SIZE，SHARED_POOL_SIZE，LARGE_POOL_SIZE，andJAVA_POOL_SIZEinitializationparameterscontainazerovalue.Whatdoesthisimply？（）A.TheSGA_TARGETinitializationparametercannotbesettoavaluelessthan1GB.TheSGA_TARGETinitializationparametercannotbesettoavaluegreaterthan1GC.TheMemoryAdvisoroftheOracleEnterpriseManager10gcannotbeusedtoobtainadviceontheimportantmemorycomponentsoftheSGAD.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.
TheAutomaticSharedMemoryManagementfeatureisenabledforthePRODdatabase.Currently，alotofinsertactivityistakingplaceinthedatabase，andthememorystructuresareallocatedaccordingtothedatabaseworkload.Astheworkloadreduces，youdecidetoperformbatchjobsinthedatabase.WhichofthefollowinginitializationparametersareNOTautomaticallyresizedaccordingtothenewworkloadandcontinuetoremainunchanged？（）A.LOG_BUFFERB.DB_CACHE_SIZEC.JAVA_POOL_SIZED.LARGE_POOL_SIZEE.SHARED_POOL_SIZEF.STREAMS_POOL_SIZE
UsingOracleEnterpriseManagertosetSGApoolvaluesmanually,forwhichofthefollowingpoolsdoesOracleEMofferadvicetosetthevalueappropriately?() A.DB_CACHE_SIZEB.SHARED_POOL_SIZEC.LARGE_POOL_SIZED.JAVA_POOL_SIZEE.SGA_MAX_SIZEF.SORT_AREA_SIZE
TomanuallyconfiguretheSGAcomponentsusingOracleEnterpriseManagerMemoryAdvisor,youcansetvaluesforwhichofthefollowinginitializationparameters?() A.DB_CACHE_SIZEB.SHARED_POOL_SIZEC.LARGE_POOL_SIZED.JAVA_POOL_SIZEE.SGA_MAX_SIZEF.SORT_AREA_SIZE
煤的主要化学特性是什么？