Oracle初始化参数设置

文章作者 100test 发表时间 2007:03:14 13:39:12
来源 100Test.Com百考试题网

本文介绍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.
0drop rollback segment rb1.
0drop rollback segment rb2.
0drop rollback segment rb3.
0drop rollback segment rb4.
0drop rollback segment rb5.
0drop rollback segment rb6.
0drop rollback segment rb7.
0drop rollback segment rb8.
0drop rollback segment rb9.
0drop rollback segment rb10.
0drop rollback segment rb11.
0drop rollback segment rb12.
0drop rollback segment rb13.
0drop rollback segment rb14.
0drop rollback segment rb15.
0drop 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 0drop logfile c:/orant/database/log1orcl.ora.
alter database 0drop logfile c:/orant/database/log2orcl.ora.
alter database 0drop logfile c:/orant/database/log3orcl.ora.
alter database 0drop 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