我要投稿
  • 您当前的位置:57365.com -> 技术教程 -> 数据库教程 -> ORACLE教程 -> 教程内容
  • [ 收藏本页教程 ]
  • oracle初始化参数设置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

    我要投稿   -   广告合作   -   关于本站   -   友情连接   -   网站地图   -   联系我们   -   版权声明   -   设为首页   -   加入收藏   -   网站留言
    Copyright © 2009 - 20012 www.www.hxswjs.com All Rights Reserved.57365.com 版权所有