oracle初始化参数设置的详细教程

　　今天小编给大家分享一篇关于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

　　

　　以上就是oracle初始化参数设置的详细教程了，想必都了解了吧，更多相关内容请继续关注爱站技术频道。