In this blog I thought we would discuss compression advisor (DBMS_COMPRESSION) a bit, it’s a free, and often overlooked tool that can be used with Oracle...
In this blog I thought we would discuss compression advisor (DBMS_COMPRESSION) a bit, it’s a free, and often overlooked tool that can be used with Oracle Database Enterprise Edition to estimate compression ratios for Advanced Row Compression, Hybrid Columnar Compression, LOBS and Advanced Index Compression. The DBMS_COMPRESSION PL/SQL package gathers compression-related information within a database environment. This includes estimating the compressibility of both partitioned...
In this blog I thought we would discuss compression advisor (DBMS_COMPRESSION) a bit, it’s a free, and often overlooked tool that can be used with Oracle Database Enterprise Edition to estimate...
HybridColumnar Compression (HCC) is a very unique feature in that it gives a verybig gain in compression ratios (10x on average), makes table scans run a...
HybridColumnar Compression (HCC) is a very unique feature in that it gives a verybig gain in compression ratios (10x on average), makes table scans run a lotfaster (up to 10x), and all this not for a subset of DW scenarios, but forevery DW use case. HCC is used by most if not all Exadata DW customers andPOCs. The only real limitation of HCC infirst release was that it was not suited for data that is actively beingmodified (thought it can be still used in such environments as...
HybridColumnar Compression (HCC) is a very unique feature in that it gives a verybig gain in compression ratios (10x on average), makes table scans run a lotfaster (up to 10x), and all this not for a...
There are various Hybrid Columnar Compression (HCC) session level statistics available to help identify space savings, Exadata Offload benefits and other query...
There are various Hybrid Columnar Compression (HCC) session level statistics available to help identify space savings, Exadata Offload benefits and other query benefits with this feature. Since the statistic descriptions didn’t make it into the Oracle Reference manual and have been confusing for many since they were introduced in 11.2, I thought it was a good idea to list few of the critical ones that can help you get an idea of benefits of HCC. Statistic Name Description...
There are various Hybrid Columnar Compression (HCC) session level statistics available to help identify space savings, Exadata Offload benefits and other query benefits with this feature. Since the...
Similar to last week, in this blog we’regoing to discuss some of the most common, user asked, questions related to HybridColumnar Compression (HCC), these...
Similar to last week, in this blog we’regoing to discuss some of the most common, user asked, questions related to HybridColumnar Compression (HCC), these questions include: Howto enable Hybrid Columnar Compression for existing tables and partitions? Whichapplications (OLTP or Data Warehouse) are best for Hybrid Columnar Compression? DoesHybrid Columnar Compression require a separate license? For existingtables and partitions, there are three best practice approaches to...
Similar to last week, in this blog we’regoing to discuss some of the most common, user asked, questions related to HybridColumnar Compression (HCC), these questions include: Howto enable...