oracle初始化參數(shù)設(shè)置
更新時(shí)間:2007年03月06日 00:00:00 作者:
正在看的ORACLE教程是:oracle初始化參數(shù)設(shè)置。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(服務(wù)器要增大10倍)
LOG_BUFFERS=655360
SORT_AREA_SIZE=327680(服務(wù)器要增大100倍)----------添加
GLOBAL_NAME=FALSE
ROLLBACK_SEGEMENTS=(RB1,RB2)//一般大型數(shù)據(jù)庫(kù)要建立6-8個(gè)回滾段
添加:
DML_LOCKS=1000
OPEN_CURSORS=200
<
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(服務(wù)器要增大10倍)
LOG_BUFFERS=655360
SORT_AREA_SIZE=327680(服務(wù)器要增大100倍)----------添加
GLOBAL_NAME=FALSE
ROLLBACK_SEGEMENTS=(RB1,RB2)//一般大型數(shù)據(jù)庫(kù)要建立6-8個(gè)回滾段
添加:
DML_LOCKS=1000
OPEN_CURSORS=200
<
您可能感興趣的文章:
相關(guān)文章
Oracle9i 動(dòng)態(tài)SGA,PGA特性探索
雖然Oracle9i中的內(nèi)存管理仍然需要很多的手工操作,不過(guò)大部分的Oracle管理員可以使用工具來(lái)連續(xù)地監(jiān)控Oracle SGA中的內(nèi)存使用,并且可以根據(jù)Oracle instance中現(xiàn)在的使用情況來(lái)自動(dòng)地重新分配內(nèi)存。2009-03-03在Linux系統(tǒng)上同時(shí)監(jiān)控多個(gè)Oracle數(shù)據(jù)庫(kù)表空間的方法
這篇文章主要介紹了在Linux系統(tǒng)上同時(shí)監(jiān)控多個(gè)Oracle數(shù)據(jù)庫(kù)表空間的方法,文中給出了shell腳本以及統(tǒng)計(jì)數(shù)據(jù)的錄入寫(xiě)法,需要的朋友可以參考下2016-01-01利用windows任務(wù)計(jì)劃實(shí)現(xiàn)oracle的定期備份
我們搞數(shù)據(jù)庫(kù)管理系統(tǒng)的經(jīng)常會(huì)遇到數(shù)據(jù)庫(kù)定期自動(dòng)備份的問(wèn)題,有各種各樣的方法,這里介紹一種利用windows任務(wù)計(jì)劃實(shí)現(xiàn)oracle定期備份的方法供大家分享。2009-08-08oracle中的greatest 函數(shù)和 least函數(shù)示例代碼
這篇文章主要介紹了oracle中的greatest 函數(shù)和 least函數(shù)的實(shí)例代碼,非常不錯(cuò),具有一定的參考借鑒價(jià)值 ,需要的朋友可以參考下2018-11-11Linux中Oracle數(shù)據(jù)庫(kù)備份
在Linux中Oracle數(shù)據(jù)庫(kù)備份的方法有很多,就像mysql一樣可以使用不同方法進(jìn)行備份oracle數(shù)據(jù)庫(kù)2013-11-11通過(guò)實(shí)例了解Oracle序列Sequence使用方法
這篇文章主要介紹了通過(guò)實(shí)例了解Oracle序列Sequence使用方法,文中通過(guò)示例代碼介紹的非常詳細(xì),對(duì)大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值,需要的朋友可以參考下2020-09-09Oracle?查詢語(yǔ)句限制只選擇最前面幾行和最后面幾行的實(shí)現(xiàn)方式
在Oracle中,可以使用?ROWNUM?關(guān)鍵字來(lái)限制查詢結(jié)果的行數(shù),這篇文章主要介紹了Oracle?查詢語(yǔ)句限制只選擇最前面幾行和最后面幾行的實(shí)現(xiàn)方式,需要的朋友可以參考下2023-12-12