ALTER DATABASE DATAFILE'd: /ORANT/DATABASE/USER1ORCL.ORA 'RESIZE 1000M; CREATE TABLESPACE INDEX_DATA DATAFILE'd: / ORANT / DATABASE / INDEX_DATA' SIZE 500M; ALTER DATABASE DATAFILE'd: /ORANT/DATABASE/RBS1ORCL.ORA ' Resize 300m; Alter Database DataFile'd: /oant/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.oran '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: = DB_BLOCK_BUFFERS * DB_BLOCK_SIZE Share_pool_size log_buffrs sort_arer_size 1m = 1 / 3--1 / 2 Take 128M as an Example:
DB_BLOCK_BUFFERS = 16000 (db_block_size = 2k) SHARE_POOL_SIZE = 30720000 (server to be increased 10 times) LOG_BUFFERS = 655360SORT_AREA_SIZE = 327680 (100-fold increase for a server) ---------- added GLOBAL_NAME = FALSEROLLBACK_SEGEMENTS = (RB1, RB2) // General large database to establish 6-8 backgrous
Add: DML_LOCKS = 1000Open_Cursors = 200
