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