??D?3?ê??ˉ2?êy×?ó°?ìOracle?μí3D??ü

读书人IT频道reader8.com/exam/jisuanji/ ê2?′ê?SGA￡¨?μí3è?????￡? 1?￠?μí3è?????￡¨SGA￡?ê?ò???·?????Oracle μ?°üo?ò??? Oracle êμàyμ?êy?Y?aμ?????D??￠?ú′????￡
?? ?÷òa°üà¨êy?Y?a???ù?o′?(the database buffer cache)￡?
?? ???Yè????o′?￡¨the redo log buffer￡?￡?
?? 12?í3?￡¨the shared pool￡?￡?
?? êy?Y×?μ??o′?￡¨the data dictionary cache￡?ò??°???ü?÷·???μ?D??￠?￡
db_block_buffers 1?￠êy?Y???ù?o3???
2?￠·??ê1yμ?êy?Y??·??ú?aò????ú′???óò￡???2?êy??′ó￡?Oracle?ú?ú′??D?òμ??àí?êy?Yμ??é?üD??í??′ó￡?ò2?′?ó?ìá?2é?ˉ?ù?è?￡
3?￠db_block_buffersò??é?aμ￥??￡??ùè?DB_BLOCK_SIZE=2K￡?db_block_buffers=3200￡??ò??ó??ú′?=3200*2K=6400K?￡
share_pool_size 1?￠SQL12?í?o3?3?
2?￠??2?êyê??a???ù?o′?oíêy?Y×?μ?μ????ù?o′??￡
Log_buffer 1?￠???Yè????o3???
sort_area_size 1?￠??Dò??
processes 1?￠í?ê±á??óμ???3ìêy
global_names 1?￠è?1??°êy?Y?aá′?·???±oí?ü?ùòaá??óμ??°êy?Y?a?±óμóD?àí?μ???×?￡??òéè??global_names = TRUE￡?
?? ·??ò￡?éè??global_names = FALSE 读书人IT频道reader8.com/exam/jisuanji/

查看更多 下一篇