oracle初始化参数设置

2016-01-29 14:47 2 1 收藏

oracle初始化参数设置,oracle初始化参数设置

【 tulaoshi.com - 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

来源:https://www.tulaoshi.com/n/20160129/1494219.html

上一篇： ORACLE的客户端如何连接到数据库
下一篇： PHP聊天室技术

看过《oracle初始化参数设置》的人还看了以下文章更多>>

Linux内核初始化过程简要介绍

标签： Linux Linux命令 Linux安装 Linux编程 Linux桌面 Linux软件 Linux内核 Linux管理

全部引导过程是四步 1:boot PROM phase 2:boot Programs phase 3:kernel initialization phase 4:init phase system初始化,检测内存和cpu,检查设备和创建设备树,设置console kernel初始化过程 kernel self -initialization 内核自检 loading of kernel modules 载入内核模块 rea...

Java对象初始化顺序的使用

标签：编程语言网络编程

单一类：（静态成员变量&静态初始化块)(成员变量&初始化块)构造函数代码如下： public class 对象初始化顺序 { public static void main(String[] args){ Person p = new Person(); } } class Person{ public static String staticf...

深入理解final变量的初始化

标签：编程语言网络编程

final变量的初始化位置一是其定义处，也就是说在final变量定义时直接给其赋值，二是在构造函数中。而且在Java1.1以前，只能是在定义时给值。三是在初如化代码块中{} 或者 static{} 代码如下： public class InitOrder { { System.out.println("before---field"); ...

关于初始化C++类成员

标签：编程语言网络编程

在使用C++编程的过程当中，经常需要对类成员进行初始化，通常的方法有两种：第一种方法： CMYClass::CSomeClass(){x=0;y=1;} 第二种方法： CSomeClass::CSomeClass() : x(0), y(1){} 本文将要探讨这两种方法的异同以及如何使用这两种方法。从技术上说，第二种方法比较好，但是在大多数情况下，两者实际上没有什么区...

Photoshop参数设置调整图片背景颜色