ORACLE EXAM

Posted on 2011-12-14 17:39 killdbs 阅读(78) 评论(0)  编辑  收藏 所属分类: ORACLE
1. db_block_size,db_block_buffers,db_cache_size
    db_block_size:oracle read/write unit,Do not alter it afterward,standard block.
    db_block_buffers:before 9i, db_buffer_chche=db_block_buffers*db_block_size, DB_BLOCK_BUFFERS to control the size of the buffer cache
    db_cache_size:specifies the size of the DEFAULT buffer pool for buffers with the primary block size .
    db_nk_cache_size::specifies the size of the buffer pool for non standard block.
2. sga_max_size : the maxsize of sga
                           specify the maxsize mem of os acllocate the oracle database.
                           static
    sga_target: the maxsize of sga.
                      enable Automatic Shared Memory Management(asmm),
                      sga_taget=0 disable asmm.
                      sga_taget<=sga_max_size.
                      dynamic

只有注册用户登录后才能发表评论。


网站导航:
 

posts - 0, comments - 0, trackbacks - 0, articles - 1

Copyright © killdbs