菜单

oracle初始化参数设置

2020年2月13日 - www.2138.com

正在看的ORACLE教程是:oracle初始化参数设置。 ALTER DATABASE
DATAFILEd:ORANTDATABASEUSER1ORCL.ORA RESIZE 1000M;CREATE
TABLESPACE INDEX_DATA DATAFILEd:ORANTDATABASEINDEX_DATA SIZE
500M;ALTER DATABASE DATAFILEd:ORANTDATABASERBS1ORCL.ORA RESIZE
300M;ALTER DATABASE DATAFILEd: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_www.2138.com,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=16000SHARE_POOL_SIZE=30720000(服务器要增大10倍)LOG_BUFFERS=655360SORT_AREA_SIZE=327680(服务器要增大100倍)----------添加GLOBAL_NAME=FALSEROLLBACK_SEGEMENTS=(RB1,RB2)//一般大型数据库要建立6-8个回滚段

添加:DML_LOCKS=1000OPEN_CURSORS=200<

相关文章

发表评论

电子邮件地址不会被公开。 必填项已用*标注

网站地图xml地图