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

          主站蜘蛛池模板: 罗平县| 泸定县| 江北区| 包头市| 宁陕县| 太仓市| 临高县| 白城市| 古丈县| 白水县| 海伦市| 陆良县| 武胜县| 丰原市| 长寿区| 镇原县| 高密市| 集贤县| 绥化市| 北流市| 芜湖市| 乌审旗| 成安县| 广西| 黄浦区| 安庆市| 永清县| 朝阳区| 威远县| 朔州市| 山丹县| 垦利县| 西青区| 昌乐县| 呼图壁县| 宣汉县| 黄大仙区| 辽中县| 舟山市| 马关县| 佛坪县|