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

          主站蜘蛛池模板: 神木县| 南京市| 延长县| 来安县| 宜宾县| 潮安县| 万全县| 林芝县| 乌拉特后旗| 鄂尔多斯市| 离岛区| 葫芦岛市| 施秉县| 东丰县| 象山县| 太湖县| 永年县| 长泰县| 古丈县| 高青县| 淮南市| 长宁区| 阿勒泰市| 盈江县| 安岳县| 顺昌县| 龙胜| 钦州市| 淅川县| 大宁县| 仁布县| 天峨县| 嘉荫县| 聂拉木县| 肇源县| 胶州市| 大渡口区| 都兰县| 诏安县| 兴国县| 鲁山县|