LaGiPusHinGWitH ---- IT

Navigation

Home |

Categories

• Computer Hacking
• Computer Diary
• Computer DataBase
• Computer Propaganda
• Computer Prophile
• Computer Security
• Computer Unix

Monthly Archives

• September 2010
• October 2009
• December 2008
• November 2008
• October 2008
• September 2008
• July 2008
• May 2008
• March 2008
• December 2007
• October 2007
• September 2007
• August 2007

Most recent entries

• Create Oracle Tablespace on SAP with BRTools
• Audit on Oracle Database
• Membuat Oracle Data Guard
• Cerita Tentang Kamu
• Membuat ulang/re-create controlfile di oracle
• Membuat RMAN dengan crontab
• Saat kau hadir kembali
• Memindahkan controlfile dan redologfile pada Oracle
• Oracle Dataguard on Standart Edition
• Adakah aku dihatimu
• Instalasi 10g di HP-UX Itanium
• Instalasi OpenOffice di Slackware 12
• Syncronize archive log
• Merubah ukuran archived Log
• Alter Block Size for tablespace

Syndicate

• RSS 2.0
• Atom

Site Credits

Powered by:
ExpressionEngine

Design by:
BlogMoxie

Cleansing-temp-Tablespace.txt

Apabila ukuran temporary tabelspace mulai membengkak, ini tentu mempengaruhi kinerja dari database Oracle.
Oleh karena itu kita harus mengecilkan ukurannya, lebih tepatnya sih menggantinya dengan temporary tablespace yang baru. Ok langsung saja, ini adalah langkah-langkah teknisnya :

1. ALTER DATABASE TEMPFILE ‘/app/oracle/oradata/db2006/temp01.dbf’ resize 500M;
2. CREATE TEMPORARY TABLESPACE temp2
TEMPFILE ‘/app/oracle/oradata/db2006/temp2_01.dbf’ SIZE 500M REUSE
AUTOEXTEND ON NEXT 100M MAXSIZE unlimited
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10M;
3. ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp2;
4. DROP TABLESPACE temp INCLUDING CONTENTS AND DATAFILES;
5. CREATE TEMPORARY TABLESPACE temp
TEMPFILE ‘/app/oracle/oradata/db2006/temp01.dbf’ SIZE 500M REUSE
AUTOEXTEND ON NEXT 100M MAXSIZE unlimited
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10M;
6. ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp;
7. DROP TABLESPACE temp2 INCLUDING CONTENTS AND DATAFILES;

Ok, sekarang ukuran temporary tablespace kita sudah sesuai dengan keinginan kita.