Test 11g compression performance

Test11gCompression performance

Comprehensive results:

After compress is set for the 11g top-up table, the default value is enabled direct load only. ONLY append can be inserted through the DIRECT path, and sqlldr can be compressed. The compression ratio is the same as the optimal ratio of normal move compress. apped, there is no obvious difference between sqlldr (oracle adopts the same insertion type Compression Algorithm). When compress for all operations is set for a table, normal insertion can be compressed, but the compression ratio is not directly inserted into the compression ratio, but the results are close, this new feature is more ideal, but 11G still causes row migrate during decompression.

Data results:

Normal insert in a common table, with 13 blocks. After moving compress, the optimal compression size is 8 blocks and the compression ratio is 38%.

After compress is set in the table, the general insert is 12 blocks, and the compression ratio is 7%.

Append after compress is set for the table, with 8 blocks and a compression ratio of 38%

Sqlldr after compress is set for the table, which is 8 blocks and the compression ratio is 38%.

General insert after compress for all operations is set in the table, with 9 blocks and a compression ratio of 30%.

11gr2 with for oltp will get better compression effect (for general insert)