当前位置： 移动技术网 > IT编程>数据库>Oracle > oracle初始化参数设置

oracle初始化参数设置

2017年12月12日  | 移动技术网IT编程  | 我要评论

加勒比女海盗主演,为什么向华强怕刘銮雄,牛牛炸潜艇

正在看的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

您可能感兴趣的文章:

如对本文有疑问，请在下面进行留言讨论，广大热心网友会与你互动！！ 点击进行留言回复

相关文章:

验证码：
最近更新的文章
大家感兴趣的文章
移动技术网