oracle initializes parameter Settings

2020-05-06 11:50:33
OfStack
                    The ORACLE tutorial you are looking at is :oracle initialization parameter Settings. 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 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:\orant\database\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;

alter 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 configuration: 

SGA=db_block_buffers*db_block_size+share_pool_size+log_buffers+sort_arer_size+1m

 =1/3--1/2

Take 128M: 

DB_BLOCK_BUFFERS=16000 (db_block_size=2k) 

SHARE_POOL_SIZE=30720000(the server is 10 times larger)

LOG_BUFFERS=655360

SORT_AREA_SIZE=327680 -- add 

GLOBAL_NAME=FALSE

ROLLBACK_SEGEMENTS=(RB1,RB2)// generally, a large database needs to establish 6-8 rollback segments 

Add: 

DML_LOCKS=1000

OPEN_CURSORS=200