oracle初始化参数设置
发布时间：2021-12-28 20:54:54 所属栏目：教程 来源：互联网
导读：正在看的ORACLE教程是:oracle初始化参数设置。 ALTER DATABASE DATAFILEd:ORANTDATABASEUSER1ORCL.ORA RESIZE 1000M; CREATE TABLESPACE INDEX_DATA DATAFILEd:ORANTDATABASEINDEX_DATA SIZE 500M; ALTER DATABASE DATAFILEd:ORANTDATABASERBS1ORCL.
|
正在看的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_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 （编辑：ASP站长） 【免责声明】本站内容转载自互联网，其相关言论仅代表作者个人观点绝非权威，不代表本站立场。如您发现内容存在版权问题，请提交相关链接至邮箱：bqsm@foxmail.com，我们将及时予以处理。 |
相关内容
未处理完善
-
无相关信息
最新更新