Home » UNIX » AIX » OLTP Compression Oracle 11g mantap !!

OLTP Compression Oracle 11g mantap !!

Pages

March 2011
M T W T F S S
« Feb   Apr »
 123456
78910111213
14151617181920
21222324252627
28293031  

RSS Link

  • An error has occurred; the feed is probably down. Try again later.

Twitter Updates

Blog Stats

  • 345,611 hits

Archives

Pengunjung


Kemaren mencoba lagi compression untuk jenis OLTP compression di Oracle 11g & SAP R/3 4.7. Table yang dicompress adalah MSEG dengan size 126 GB. Proses compression dengan online reorganization dan parallel table 4 memakan waktu sekitar 3,5 jam (no user login).

Hasilnya table MSEG saat ini hanya berukuran 15 GB. Jadi size berkurang sekitar (126 – 15) 111 GB. Woww…

Kayaknya makin yakin aja neeh untuk segera diterapkan di sistem DEV, QA, dan PRD.


1 Comment

  1. Table compression is the best new feature of Oracle 11g. It is more useful in data warehousing.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: