网友您好， 请在下方输入框内输入要搜索的题目：

题目内容 （请给出正确答案）

AutomaticSharedMemoryManagement(ASMM)hasbeenenabledforyourdatabaseinstance.The initializationparametersforthecomponentsthataremanagedbyASMMarenotset.AfterobservingtheeffectsofASMM,youexecutedthefollowingcommand: SQL>ALTERSYSTEMSETDB_CACHE_SIZE=100M;Whichstatementistrueinthisscenario()

A.Theminimummemorysizeforthedatabasebuffercacheissetto100mb.

B.ThemaximummemorysizethatcanbeobtainedbythedatabasebuffercacheduringASMMissetto100mb

C.Theminimummemorysizeallocatedforaserverprocessinthedatabasebuffercacheindedicatedmodeissetto100mb.

D.ThemaximummemorysizefromthedatabasebuffercachethatcanbereleasedfordynamicdistributionduringASMMissetto100mb

参考答案

更多 “ AutomaticSharedMemoryManagement(ASMM)hasbeenenabledforyourdatabaseinstance.The initializationparametersforthecomponentsthataremanagedbyASMMarenotset.AfterobservingtheeffectsofASMM,youexecutedthefollowingcommand: SQLALTERSYSTEMSETDB_CACHE_SIZE=100M;Whichstatementistrueinthisscenario()A.Theminimummemorysizeforthedatabasebuffercacheissetto100mb.B.ThemaximummemorysizethatcanbeobtainedbythedatabasebuffercacheduringASMMissetto100mbC.Theminimummemorysizeallocatedforaserverprocessinthedatabasebuffercacheindedicatedmodeissetto100mb.D.ThemaximummemorysizefromthedatabasebuffercachethatcanbereleasedfordynamicdistributionduringASMMissetto100mb ” 相关考题
考题 ViewExhibit1andExhibit2toexaminethecurrentmemoryallocationandparametersettings,respectively.Whyareadvisorsnotavailableforthesharedpoolandthebuffercache() A.becausetheDB_CACHE_ADVICEparameterissettoOFFB.becauseAutomaticMemoryManagement（AMM）isdisabledforthedatabaseinstanceC.becauseAutomaticSharedMemoryManagement（ASMM）isenabledforthedatabaseinstanceD.becausethevaluesfortheDB_CACHE_SIZEandSHARED_POOL_SIZEparameterswerenotsetinitially
查看答案
考题 AutomaticSharedMemoryManagement（ASMM）hasbeenenabledforyourdatabaseinstance.TheinitializationparametersforthecomponentsthataremanagedbyASMMarenotset.AfterobservingtheeffectsofASSM，youexecutedthefollowingcommand：SQLALTERSYSTEMSETDB_CACHE_SIZE=100M；Whichstatementistrueinthisscenario（）A.Theminimummemorysizeforthedatabasebuffercacheissetto100mb.B.ThemaximummemorysizethatcanbeobtainedbythedatabasebuffercacheduringASMMissetto100mbC.Theminimummemorysizeallocatedforaserverprocessinthedatabasebuffercacheindedicatedmodeissetto100mb.D.ThemaximummemorysizefromthedatabasebuffercachethatcanbereleasedfordynamicdistributionduringASMMissetto100mb
查看答案
考题 Examine the following parameters for a database instance: MEMORY_MAX_TARGET=0MEMORY_TARGET=0SGA_TARGET=0PGA_AGGREGATE_TARGET=500mWhich three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)?（）A. LOG_BUFFERB. SORT_AREA_SIZEC. JAVA_POOL_SIZED. STREAMS_POOL_SIZEE. DB_16K_CACHE_SZIEF. DB_KEEP_CACHE_SIZE
查看答案
热门标签
最新试卷