oracle参数设置:oracle初始化参数设置来源: 发布时间:星期五, 2009年4月3日 浏览:0次 评论:0
="t18">
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" _disibledevent=> =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)// ![]() 添加: DML_LOCKS=1000 OPEN_CURSORS=200 0
相关文章读者评论发表评论 |
|