oracle初始化参数设置

发布时间:2022-04-20 发布网站:脚本宝典
脚本宝典收集整理的这篇文章主要介绍了oracle初始化参数设置脚本宝典觉得挺不错的,现在分享给大家,也给大家做个参考。
正在看的oracle教程是:oracle初始化参数设置。ALTER DATABASE DATAFILE'd:ORANTDATABASEUSER1ORCL.ORA' RESIZE 1000M;
CREATE TABLESPACE INDEX_DATA DATAFILE'd:ORANTDATABASeiNDEX_DATA' SIZE 500M;
ALTER DATABASE DATAFILE'd:ORANTDATABASERBS1ORCL.ORA' RESIZE 300M;
ALTER DATABASE DATAFILE'd:ORANTDASTABASEtmp1ORCL.ORA' RESIZE 300M;

alter rollback segment "RB1" offline;
alter rollback segment "RB2" offline;
alter rollback segment "RB3" offline;
alter rollback segment "RB4" offline;
alter rollback segment "RB5" offline;
alter rollback segment "RB6" offline;
alter rollback segment "RB7" offline;
alter rollback segment "RB8" offline;
alter rollback segment "RB9" offline;
alter rollback segment "RB10" offline;
alter rollback segment "RB11" offline;
alter rollback segment "RB12" offline;
alter rollback segment "RB13" offline;
alter rollback segment "RB14" offline;
alter rollback segment "RB15" offline;
alter rollback segment "RB16" offline;

drop rollback segment "RB1";
drop rollback segment "RB2";
drop rollback segment "RB3";
drop rollback segment "RB4";
drop rollback segment "RB5";
drop rollback segment "RB6";
drop rollback segment "RB7";
drop rollback segment "RB8";
drop rollback segment "RB9";
drop rollback segment "RB10";
drop rollback segment "RB11";
drop rollback segment "RB12";
drop rollback segment "RB13";
drop rollback segment "RB14";
drop rollback segment "RB15";
drop rollback segment "RB16";

create rollback segment "RB1" tablespace "ROLLBACK_DATA" storage (inITial 1m next 1m);
create rollback segment "RB2" tablespace "ROLLBACK_DATA" storage (initial 1m next 1m);
create rollback segment "RB3" tablespace "ROLLBACK_DATA" storage (initial 1m next 1m);
create rollback segment "RB4" tablespace "ROLLBACK_DATA" storage (initial 1m next 1m);
create rollback segment "RB5" tablespace "ROLLBACK_DATA" storage (initial 1m next 1m);
create rollback segment "RB6" tablespace "ROLLBACK_DATA" storage (initial 1m next 1m);


alter rollback segment "RB1" online;
alter rollback segment "RB2" online;
alter rollback segment "RB3" online;
alter rollback segment "RB4" online;
alter rollback segment "RB5" online;
alter rollback segment "RB6" online;


alter database add LOGfile 'c:orantdatabaselog1.ora' size 10m;
alter database add logfile 'c:orantdatabaselog2.ora' size 10m;
alter database add logfile 'c:orantdatabaselog3.ora' size 10m;
alter database add logfile 'c:orantdatabaselog4.ora' size 10m;
alter database drop logfile 'c:orantdatabaselog1orcl.ora';
alter database drop logfile 'c:orantdatabaselog2orcl.ora';
alter database drop logfile 'c:orantdatabaselog3orcl.ora';
alter database drop logfile 'c:orantdatabaselog4orcl.ora';


INITORAL.ORA配置:
SGA=db_block_buffers*db_block_size+share_pool_size+log_buffers+sort_arer_size+1m
   =1/3--1/2
以128M为例



DB_BLOCK_BUFFERS=16000(db_block_size=2k)
SHARE_POOL_SIZE=30720000(服务器要增大10倍)
LOG_BUFFERS=655360
SORT_AREA_SIZE=327680(服务器要增大100倍)----------添加
GLOBAL_NamE=FALSE
ROLLBACK_SEGEMENTS=(RB1,RB2)//一般大型数据库要建立6-8个回滚段

添加:
DML_LOCKS=1000
OPEN_CURSORS=200

脚本宝典总结

以上是脚本宝典为你收集整理的oracle初始化参数设置全部内容,希望文章能够帮你解决oracle初始化参数设置所遇到的问题。

如果觉得脚本宝典网站内容还不错,欢迎将脚本宝典推荐好友。

本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。
标签: