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

题目内容 (请给出正确答案)

Youhaveexecutedthiscommandtochangethesizeofthedatabasebuffercache:SQL>ALTERSYSTEMSETDB_CACHE_SIZE=2516582;Systemaltered.Toverifythechangeinsize,youexecutedthiscommand:SQL>SHOWPARAMETERDB_CACHE_SIZENAMETYPEVALUE------------------------------------------------db_cache_sizebiginteger4194304(4M)Whyisthevaluesetto4194304andnotto2516582()

A.because4194304isthegranulesize

B.because4194304isthestandardblocksize

C.because4194304isthelargestnonstandardblocksizedefinedinthedatabase

D.because4194304isthetotalsizeofdataalreadyavailableinthedatabasebuffercache


参考答案

更多 “ Youhaveexecutedthiscommandtochangethesizeofthedatabasebuffercache:SQLALTERSYSTEMSETDB_CACHE_SIZE=2516582;Systemaltered.Toverifythechangeinsize,youexecutedthiscommand:SQLSHOWPARAMETERDB_CACHE_SIZENAMETYPEVALUE------------------------------------------------db_cache_sizebiginteger4194304(4M)Whyisthevaluesetto4194304andnotto2516582()A.because4194304isthegranulesizeB.because4194304isthestandardblocksizeC.because4194304isthelargestnonstandardblocksizedefinedinthedatabaseD.because4194304isthetotalsizeofdataalreadyavailableinthedatabasebuffercache ” 相关考题
考题 Youhaveexecutedthiscommandtochangethesizeofthedatabasebuffercache:SQL>ALTERSYSTEMSETDB_CACHE_SIZE=2516582;Systemaltered.Toverifythechangeinsize,youexecutedthiscommand:SQL>SHOWPARAMETERDB_CACHE_SIZENAMETYPEVALUE------------------------------------------------db_cache_sizebiginteger4194304Whyisthevaluesetto4194304andnotto2516582()A.Because4194304isthegranulesizeB.Because4194304isthestandardblocksizeC.Because4194304isthelargestnonstandardblocksizedefinedinthedatabaseD.Because4194304isthetotalsizeofdataalreadyavailableinthedatabasebuffercache