導讀:1建站知識oracle初始化參數設置網站seo優化課程營銷型網站建設。

正在看的ORACLE教程是:oracle初始化參數設置。 ALTER DATABASE DATAFILEd:\ORANT\DATABASE\USER1ORCL.ORA RESIZE 1000M;CREATE TABLESPACE INDEX_DATA DATAFILEd:\ORANT\DATABASE\INDEX_DATA SIZE 500M;ALTER DATABASE DATAFILEd:\ORANT\DATABASE\RBS1ORCL.ORA RESIZE 300M;ALTER DATABASE DATAFILEd:\ORANT\DASTABASE\TMP1ORCL.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 segme網站推廣優化seont "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:\orant\d營銷型網站建設atabase\log1.ora size 10m;alter database add logfile c:\orant\database\log2.ora size 10m;alter database add logfile c:\orant\database\log3.ora size 10m;alt網站建設制作er database add logfile c:\orant\database\log4.ora size 10m;alter database drop logfile c:\orant\database\log1orcl.ora;alter database drop logfile c:\orant\database\log2orcl.ora;alter database drop logfile c:\orant\database\log3orcl.ora;alter database drop logfile c:\orant\database\log4orcl.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=655360SORT_AREA_SIZE=327680(服務器要增大100倍)－－－－－－－－－－添加GLOBAL_NAME=FALSEROLLBACK_SEGEMENTS=(RB1,RB2)//一般大型數據庫要建立6－8個回滾段

關鍵詞標簽: 初始化 參數設置