oracle初始化参数设置

作者：字体：[增加减小] 来源：互联网时间：2017-05-11

通过本文主要向大家介绍了oracle 初始化参数,oracle初始化,oracle初始化失败,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

<

</div>

分享到：QQ空间新浪微博腾讯微博微信百度贴吧 QQ好友复制网址打印

您可能想查找下面的文章:

2017-05-11ORACEL使用脚本来修改表结构
2017-05-11ORACLE数据库空间整理心得
2017-05-11在Mac OS上安装Oracle数据库的基本方法
2017-05-11oracle实现多行合并的方法
2017-05-11ORACLE常见错误代码的分析与解决（一）
2017-05-11oracle 索引不能使用深入解析
2017-05-11oracle sql 去重复记录不用distinct如何实现
2017-05-11在oracle 数据库查询的select 查询字段中关联其他表的方法
2017-05-11Oralce中VARCHAR2()与NVARCHAR2()的区别介绍
2017-05-11rman备份脚本和rman增量备份脚本分享

oracle初始化参数设置

您可能想查找下面的文章:

相关文章

文章分类

最近更新的内容