AutomaticSharedMemoryManagement（ASMM）hasbeenenabledforyourdatabaseinstance.TheinitializationparametersforthecomponentsthataremanagedbyASMMarenotset.AfterobservingtheeffectsofASSM，youexecutedthefollowingcommand：SQLALTERSYSTEMSETDB_CACHE_SIZE=100M；Whichstatementistrueinthisscenario（）A.Theminimummemorysizeforthedatabasebuffercacheissetto100mb.B.ThemaximummemorysizethatcanbeobtainedbythedatabasebuffercacheduringASMMissetto100mbC.Theminimummemorysizeallocatedforaserverprocessinthedatabasebuffercacheindedicatedmodeissetto100mb.D.ThemaximummemorysizefromthedatabasebuffercachethatcanbereleasedfordynamicdistributionduringASMMissetto100mb

AutomaticSharedMemoryManagement（ASMM）hasbeenenabledforyourdatabaseinstance.TheinitializationparametersforthecomponentsthataremanagedbyASMMarenotset.AfterobservingtheeffectsofASSM，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
查看答案
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
查看答案
热门标签