网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
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
考题
煤的主要化学特性是什么?
热门标签
最新试卷