Tips: Add to Google | Oracle DUL? | AUL License | WebChart | asyncdata | ociuldr

Contact: anysql©yahoo.com/anysql©126.com, MSN: loufangxin©msn.com, AIM: loufangxin

SQLULDR2 can compress the output file in GZIP format

    Data compress can save a lot of storage for data archiving, GZIP is a good choise between the compress ratio and compress speed, many utilities support GZIP feature, such as rsync with "-z" option. I spent some days...

Tags:

Posted on April 17, 2009 4:37 PM

What's Oracle 11G's compress table support for OLTP system?

    Before Oracle 11g, the data will not be compressed by normal insert statement even if the table is created with compress option. If you want to compress a tables data, you need to move table as compressed, or...

Tags:

Posted on November 16, 2007 6:43 PM

AUL 5 Beta version launched, all features under testing.

    Oracle compress can save a lot of storage for us, so I believe that more and more companys will start to use it. I spent few days free time on it, and add the compress feature support in...

Tags:

Posted on November 2, 2007 5:58 PM

Oracle Compress Table Block Format (3)

    The compress block format seems not so much complex as I expected. After spent few hours, I can get the same dump information from AUL as dump datafile command do. Left side comes from Oracle dump datafile command,...

Tags:

Posted on November 1, 2007 3:19 PM

Oracle Compress Table Block Format (2)

    In previous test, I just create table with two columns, how about for a table with a lot of columns? The basic block format does not change, the key is how to extract the rows. I get one...

Tags:

Posted on October 30, 2007 10:38 PM

Oracle Compress Table Block Format (1)

    Oracle compress table is an new feature since Oracle 9i, it could save you a lot of storage, I have seen this new feature used in data warehouse. In oracle 9i, compress table have some bugs, for example...

Tags:

Posted on October 30, 2007 9:26 PM

Poor SUN CPU speed for Oracle compress table

    We are thinking to use Oracle compress table for data archiving via TTS, by creating a single table for every month, and then moving it to a cheaper storage. Since the history data will not be modified any...

Tags:

Posted on October 30, 2007 11:28 AM