网友您好, 请在下方输入框内输入要搜索的题目:
TheSPFILEforthePRODdatabasespecifiesthefollowinginitializationparametervalues:
SGA_TARGET=2G
DB_8K_CACHE_SIZE=128M
YoucreateatablespacenamedHRwiththenon-standardblocksizeof8K.FourdatabaseusersarerunningqueriesonatableintheHRtablespace.Theseuserscomplainthatthequeriesaretakinglongerthanusualtocomplete.Whileinvestigatingthereasonsforthisdelay,youdiscoverthatthedatabaseencountersextensivecachemissesonthedatabasebuffercachewiththeblocksizeof8K.YouissuethefollowingstatementtoincreasethevalueoftheDB_8K_CACHE_SIZEinitializationparameterto256M:
SQL>ALTERSYSTEMSETDB_8K_CACHE_SIZE=256MSCOPE=BOTH;
Whatistheresultofthisstatement?()
参考答案