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 存储过程返回结果集
• ·Oracle性能究极优化 下
• ·在ORACLE中移动数据库文件
• ·ORACLE SQL性能优化系列 (五)
• ·Oracle LogMiner终结版（zt）
• ·转贴 oracle的调优
• ·Installing Oracle 10g o
• ·[转贴]如何正确利用Rownum来限制查询所返
• ·Oracle分布式系统数据复制技术