繁體中文当前位置: 首页 > 图文教程 > 数据库 > Oracle > oracle初始化参数设置
- Oracle
- Oracle归档模式
- Oracle存储过程创建和使用举例
- 通过JDBC连接oracle数据库的十大技巧
- 如何开发ORACLE存储过程
- Java调用Oracle存储过程
- Oracle性能优化
- 几种oracle数据库恢复
- 如何开发ORACLE存储过程
- 为Oracle数据库创建用户
- 用Quick Slice获取Oracle进程的线程状态
- Oracle数据库高性能秘密之数据高速缓存
- Oracle中的rownum和rowid
- Oracle表段中的高水位线HWM
- 提高Oracle性能--如何走索引
- oracle增加和修改数据文件
- oracle移植到mysql注意事项
- Oracle的几个概念:数据库名,全局数据库名,SID,实例,命名空间,schema
- 查询Oracle的BLOB类型
- Oracle备份恢复四(RMAN备份)
- 如何彻底删除oracle
Oracle 中的 oracle初始化参数设置
出处:互联网 整理: 软晨网（RuanChen.com） 发布: 2009-09-13 浏览: 90 ::
收藏到网摘: n/a
正在看的ORACLE教程是:oracle初始化参数设置。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" 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
<
评论 (0) All
