Oracle初始化引數設定new(轉)
Oracle初始化引數設定
[@more@]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
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/9417382/viewspace-937337/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORACLE RAC資料庫中的初始化引數的設定Oracle資料庫
- oracle初始化引數Oracle
- oracle中引數session和 processes的設定(轉)OracleSession
- Oracle 11G 資料庫重要的初始化引數設定Oracle資料庫
- ORACLE JOB INTERVAL引數設定Oracle
- 2.7.6.2 設定或修改初始化引數的值
- (轉)redhat下安裝oracle,設定redhat核心引數RedhatOracle
- Oracle 9i初始化引數檔案(轉)Oracle
- java 執行緒池的初始化引數解釋和引數設定Java執行緒
- Oracle CSS的引數設定 心跳時間設定OracleCSS
- Oracle幾個初始化引數Oracle
- Oracle RAC初始化引數管理Oracle
- oracle 常見初始化引數Oracle
- ORACLE初始化引數的配置Oracle
- ORACLE COL SET 設定顯示引數Oracle
- oracle 安裝相關引數設定Oracle
- Oracle歸檔引數設定問題Oracle
- 初識oracle SGA之引數設定Oracle
- Oracle初始化引數的來源Oracle
- ORACLE初始化引數:AUDIT_TRAILOracleAI
- Oracle FILESYSTEMIO_OPTIONS初始化引數Oracle
- Oracle9i初始化引數中文說明[轉貼]Oracle
- oracle中設定UTL_FILE_DIR引數Oracle
- Oracle歸檔模式、引數意義、設定Oracle模式
- Oracle安裝時shmmax引數的設定OracleHMM
- [轉貼][WCFSecurity]2.安全引數設定
- ORACLE初始化引數檔案介紹Oracle
- Oracle 並行相關的初始化引數Oracle並行
- Oracle USE_LARGE_PAGES初始化引數Oracle
- Oracle SQL92_SECURITY初始化引數OracleSQL
- 【轉】OLTP,OLAP和混合應用下oracle預設的不同的引數設定Oracle
- Oracle效能最佳化經驗分享之系統引數設定(轉)Oracle
- Oracle9.2.0.4 RAC 三節點引數設定Oracle
- Oracle 9i初始化引數檔案Oracle
- oracle10g初始化引數說明Oracle
- 【原創】Oracle 初始化引數&效能檢視Oracle
- vsftpd設定引數FTP
- RAC 特定引數設定