oracle初始化参数设置
正在看的oracle教程是:oracle初始化参数设置。 alter database datafiled:\orant\database\user1orcl.ora resize 1000m;
create tablespace index_data datafiled:\orant\database\index_data size 500m;
alter database datafiled:\orant\database\rbs1orcl.ora resize 300m;
alter database datafiled:\orant\dastabase\tmp1orcl.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:\orant\database\log1.ora size 10m;
alter database add logfile c:\orant\database\log2.ora size 10m;
alter database add logfile c:\orant\database\log3.ora size 10m;
alter database add logfile c:\orant\database\log4.ora size 10m;
alter database drop logfile c:\orant\database\log1orcl.ora;
alter database drop logfile c:\orant\database\log2orcl.ora;
alter database drop logfile c:\orant\database\log3orcl.ora;
alter database drop logfile c:\orant\database\log4orcl.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