修改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