>

oracle开首化参数设置,oracle开首化参数设置_ora

- 编辑:www.bifa688.com -

oracle开首化参数设置,oracle开首化参数设置_ora

正在看的ORACLE教程是:oracle开端化参数设置。ALTE奥迪Q5 DATABASE DATAFILE'd:ORANTDATABASEUSECRUISER1ORCL.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 ;create rollback segment "RB2" tablespace "ROLLBACK_DATA" storage ;create rollback segment "RB3" tablespace "ROLLBACK_88bifa必发唯一官网,DATA" storage ;create rollback segment "RB4" tablespace "ROLLBACK_DATA" storage ;create rollback segment "RB5" tablespace "ROLLBACK_DATA" storage ;create rollback segment "RB6" tablespace "ROLLBACK_DATA" storage ;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=16000SHARE_POOL_SIZE=30720000LOG_BUFFERS=655360SORT_AREA_SIZE=327680----------添加GLOBAL_NAME=FALSEROLLBACK_SEGEMENTS=//平时大型数据库要树立6-8个回滚段增加:DML_LOCKS=1000OPEN_CURSORS=200<

正在看的ORACLE教程是:oracle初阶化参数设置。ALTEHighlander DATABASE DATAFILE'd:ORANTDATABASEUSE昂Cora1ORCL.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=16000SHARE_POOL_SIZE=307二零零四0(服务器要增大10倍卡塔尔(قطر‎LOG_BUFFERS=655360SORT_AREA_SIZE=327680(服务器要增大100倍卡塔尔(英语:State of Qatar)----------加多GLOBAL_NAME=FALSEROLLBACK_SEGEMENTS=(RB1,RB2卡塔尔国//日常大型数据库要树立6-8个回滚段加多:DML_LOCKS=1000OPEN_CURSORS=200<

本文由88bifa必发唯一官网发布,转载请注明来源:oracle开首化参数设置,oracle开首化参数设置_ora