ITPub博客

首页 > 数据库 > Oracle > 数据库人员手边系列:Oracle初始化参数

数据库人员手边系列:Oracle初始化参数

原创 Oracle 作者:YoungEric 时间:2007-08-31 10:30:37 0 删除 编辑

[@more@]

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

P.S http://searchdatabase.techtarget.com.cn/tips/135/2134635.shtml

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10484922/viewspace-967209/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2007-12-18

  • 博文量
    79
  • 访问量
    211700