Oracle 12c New Feature – Heat Map and Automatic Data Optimization

Posted by Gavin Soorma
On September 10, 2013
0 Comments

One of the main goals of an ILM (Information Life Cycle) policy is to reduce the cost of storage, improve performance and access times for both current as well as archived data and retain data long enough so as to satisfy regulatory laws and statutes related to data preservation. As data grows rather than buy […]

Posted by Gavin Soorma
On December 1, 2009
1 Comments

Oracle 11g Release 2 introduced compression algorithm levels which can be used for compressing table data, Data Pump exports and RMAN backups as well. The compression levels are BASIC, LOW, MEDIUM and HIGH and each affords a trade off related to backup througput and the degree of compression afforded. To use this option, we can […]

Posted by Gavin Soorma
On September 3, 2009
2 Comments

Although table compression was introduced in Oracle 9i and 10g, it was aimed more at bulk load operations for data warehouse environments. The overhead associated with compression and uncompression made it unsuitable for OLTP type shops. In Oracle 11g, Advanced Compression (which is an additional licensed feature) includes OLTP compression capabilities as well as compression […]

Posted by Arjun Raja
On June 29, 2009
0 Comments

EXPORT AND IMPORT USING UNIX PIPES. Sometimes, the space on disk may not be enough to hold a full export dump if uncompressed. EXAMPLE – export schema ARJUN from PROD database and import into DEV database. To avoid space running out, unix pipes and compression can be used. EXPORT IN PROD DATABASE cd /u02/oradata/export CREATE […]

News

Oracle 12c New Feature – Heat Map and Automatic Data Optimization

11g Release 2 RMAN Backup Compression

Oracle 11g Advanced Compression

Export and Import using unix pipes and compression