oracle初始化参数设置
来源:互联网 发布:软件 研究方法 编辑:程序博客网 时间:2024/06/08 05:10
CREATE TABLESPACE INDEX_DATA DATAFILE'd:/ORANT/DATABASE/INDEX_DATA' SIZE 500M;
ALTER DATABASE DATAFILE'd:/ORANT/DATABASE/RBS1ORCL.ORA' RESIZE 300M;
ALTER DATABASE DATAFILE'd:/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初始化参数设置
- oracle 参数设置
- Oracle 参数设置
- Jquery mobile 初始化参数设置详解
- ImageLoader初始化时的参数设置
- Oracle基础知识--内存参数设置
- oracle内存参数设置
- ORACLE JOB INTERVAL参数设置
- Oracle常用参数设置
- Oracle基础知识--内存参数设置
- ORACLE JOB INTERVAL参数设置
- Oracle参数设置(10g)
- ORACLE JOB INTERVAL参数设置
- Oracle 内存参数设置
- oracle 内核参数设置
- ORACLE JOB INTERVAL参数设置
- ORACLE JOB INTERVAL参数设置
- ORACLE JOB INTERVAL参数设置
- 一、无法打开Web项目
- [转载] 图灵奖中的数学家
- 关于一个SqlServer的存储过程问题.
- Dotnet中用接口描述is和as操作符之间的区别
- 孙子兵法
- oracle初始化参数设置
- C库函数手册
- CVS 命令集
- 鼠标经过链接时,文字提示显示在页面的右下角,不会阻碍浏览者的视线
- struts1.1中的异常应用实践
- 一、无法打开ASP.NET Web项目
- struts框架中多行表单提交
- InfoHelper 项目散记(1)
- J2SE5.0新特性之ProcessBuilder