Yang menarik di 11g, compression juga dipakai di redo log transport sehingga bisa menghemat b/w dan memperkecil lag dari primary ke standby.
2009/11/25 yulius_wibowo <[email protected]> > > > Penggunaan option COMPRESS di level table atau tablespace sbb: > 1. Utk 9iR2 & 10g: > - data hanya akan dikompres ketika data dimasukkan ke dalam table > menggunakan : > - direct path insert (INSERT INTO SELECT ) dengan hint APPEND > - direct path load (menggunakan SQL*Loader) > - CTAS (CREATE TABLE ... COMPRESS AS SELECT) > > Note: compression rate-nya akan lebih bagus kalau menggunakan ORDER BY > CLAUSE. > > 2. 11g: > - bisa spt 9iR2 atau 10g > - juga bisa utk ALL OPERATIONS (DML:: INSERT biasa & UPDATE) > > cmiiw, > bw > > > --- In [email protected] <indo-oracle%40yahoogroups.com>, "a j" > <antdri...@...> wrote: > > > > wah, saya menggunakan versi 10.2.0.4. > > kalau syntax "alter tablespace <nama_tablespace> default compress" ini > buat apa yah ? > > katanya compress ini bisa me reduce space yg ada > > > > trims > > > > --- In [email protected] <indo-oracle%40yahoogroups.com>, > "Faiz" <faiz.jahja@> wrote: > > > > > > Kalau tidak salah option ini ada di Oracle 11g. > > > > > > Untuk compress table dan column adanya di Oracle 10gR2 Exadata. > > > > > > . > > > -----Original Message----- > > > From: "a j" <antdrie_j@> > > > Date: Wed, 25 Nov 2009 03:45:21 > > > To: <[email protected] <indo-oracle%40yahoogroups.com>> > > > Subject: [indo-oracle] compress table / tablespace > > > > > > ada yg sudah pernah melakukan compress table/tablespace ? > > > untuk syntax nya bagai mana yah ? > > > apa untung dan ruginya compress table/tablespace ini. > > > > > > trims > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > [Non-text portions of this message have been removed] ------------------------------------ -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [email protected] Website: http://indooracle.wordpress.com http://www.facebook.com/group.php?gid=51973053515 ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.comYahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/indo-oracle/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
