oracle初始化参数设置

2016-01-29 14:47 13 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;

(本文来源于图老师网站,更多请访问http://www.tulaoshi.com)


INITORAL.ORA配置:
SGA=db_block_buffers*db_block_size+share_pool_size+log_buffers+sort_arer_size+1m
=1/3--1/2
以128M为例:

(本文来源于图老师网站,更多请访问http://www.tulaoshi.com)

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

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

延伸阅读
一维数组的声明方式: type var[]; 或type[] var; 声明数组时不能指定其长度(数组中元素的个数), Java中使用关键字new创建数组对象,格式为: 数组名 = new 数组元素的类型 [数组元素的个数] 实例: TestNew.java: 程序代码: public class TestNew {public static void main(String args[]) { int[] s ; int i ; s = new...
  全部引导过程是四步 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...
单一类:(静态成员变量&静态初始化块)(成员变量&初始化块)构造函数 代码如下: public class 对象初始化顺序 {     public static void main(String[] args){         Person p = new Person();     } } class Person{     public static String staticf...
在使用C++编程的过程当中,经常需要对类成员进行初始化,通常的方法有两种: 第一种方法: CMYClass::CSomeClass(){x=0;y=1;} 第二种方法: CSomeClass::CSomeClass() : x(0), y(1){} 本文将要探讨这两种方法的异同以及如何使用这两种方法。     从技术上说,第二种方法比较好,但是在大多数情况下,两者实际上没有什么区...
标签: 平面设计
素材图片主色为绿色,不过调色的时候不要一步就把主色转为橙红色,需要把稍亮的绿色转为橙黄色,其它绿色转为红褐色,然后在暗部增加一点冷色即可。 原图  最终效果  1、打开素材图片,创建可选颜色调整图层,对黄、绿、中性,黑进行调整,参数设置如图1 - 4,效果如图5。这一步给图片增加黄褐色。 ...

经验教程

835

收藏

28
微博分享 QQ分享 QQ空间 手机页面 收藏网站 回到头部