修改oralce 的 init.ora 文件的方法

修改oralce 的 init.ora 文件

..1) 確定oracle的緩衝區及共享池大小，假設作如下定義：

........ db_block_size = 4096

........ db_block_buffers = 262144 # 緩衝區大小為1G

........ share_pool_size = 314572800 # 使用300M共享池

..2) 添加下列各項內容：

........ use_indirect_data_buffers = true

........ # 告訴oracle可以使用間接內存(即可以使用windows讓出來的1G內存作為數據緩衝區)

........ pre_page_sga = true

........ # 把oracle SGA鎖定到內存中，不產生頁麵交換文件(8i的參數可能是lock_sga = true)

........ # 對於一個有4G物理內存的係統來講，可能這一個參數並不是必須的

weibo.com/ttarticle/p/show?id=2309405150028875563296

weibo.com/ttarticle/p/show?yOMwz&id=2309405150028875563296

weibo.com/ttarticle/p/show?id=2309405150028900729999

weibo.com/ttarticle/p/show?rVzFu&id=2309405150028900729999

weibo.com/ttarticle/p/show?id=2309405150028959449449

weibo.com/ttarticle/p/show?XKLhR&id=2309405150028959449449

weibo.com/ttarticle/p/show?id=2309405150028984615369

weibo.com/ttarticle/p/show?MiZwo&id=2309405150028984615369

weibo.com/ttarticle/p/show?id=2309405150029039142023

weibo.com/ttarticle/p/show?HzrJo&id=2309405150029039142023

weibo.com/ttarticle/p/show?id=2309405150029068501165

weibo.com/ttarticle/p/show?yfJAw&id=2309405150029068501165

weibo.com/ttarticle/p/show?id=2309405150029122764871

weibo.com/ttarticle/p/show?lEpuw&id=2309405150029122764871

weibo.com/ttarticle/p/show?id=2309405150029148193921

weibo.com/ttarticle/p/show?BJaRV&id=2309405150029148193921

weibo.com/ttarticle/p/show?id=2309405150029269828761

weibo.com/ttarticle/p/show?WeItE&id=2309405150029269828761

weibo.com/ttarticle/p/show?id=2309405150029353714039

weibo.com/ttarticle/p/show?ZvByv&id=2309405150029353714039

weibo.com/ttarticle/p/show?id=2309405150029433406157

weibo.com/ttarticle/p/show?JFXit&id=2309405150029433406157

weibo.com/ttarticle/p/show?id=2309405150029517292047

weibo.com/ttarticle/p/show?dLdIX&id=2309405150029517292047

weibo.com/ttarticle/p/show?id=2309405150029521486192

weibo.com/ttarticle/p/show?Pwgwy&id=2309405150029521486192

weibo.com/ttarticle/p/show?id=2309405150029596984471

weibo.com/ttarticle/p/show?MVlQm&id=2309405150029596984471

weibo.com/ttarticle/p/show?id=2309405150029605372289

weibo.com/ttarticle/p/show?RTykg&id=2309405150029605372289

weibo.com/ttarticle/p/show?id=2309405150029680870347

weibo.com/ttarticle/p/show?kkPtD&id=2309405150029680870347

weibo.com/ttarticle/p/show?id=2309405150029697384561

weibo.com/ttarticle/p/show?LlDsq&id=2309405150029697384561

weibo.com/ttarticle/p/show?id=2309405150029764493345

weibo.com/ttarticle/p/show?owBSa&id=2309405150029764493345

weibo.com/ttarticle/p/show?id=2309405150029831864497

weibo.com/ttarticle/p/show?LYDal&id=2309405150029831864497

weibo.com/ttarticle/p/show?id=2309405150029844185155

weibo.com/ttarticle/p/show?EPTva&id=2309405150029844185155