什么是oracle初始化参数(oracle初始化账号密码)

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';

Initial. Ola configuration:

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

=1/3--1/2

以128M为例：

Database block buffer=16000 (database block size=2k)

SHARE_POOL_SIZE=30720000(服务器应该增加10倍)

LOG_BUFFERS=655360

SORT_AREA_SIZE=327680(服务器要增加100倍)-Add。

GLOBAL_NAME=FALSE

Rollback _ segments=(Rb1，Rb2)//一般大型数据库需要建立6-8个回滚段。

添加：

DML_LOCKS=1000

OPEN_CURSORS=200