Free Exadata Tutorials and Demonstrations

Let Oracle Certified Master DBA John Watson teach you what Exadata is and demonstrate how it works!

Oracle Exadata Database Machine

A Database Machine is a massively scalable and fault tolerant piece of hardware (CPUs, RAM, discs, and networking: all perfectly balanced) combined with the Exadata smart storage software. A really powerful database server, with a disc subsystem that understands the database and take over a huge proportion of the data processing workload. This is the “offload processing” feature: no other platform can do this.

Experience shows that porting a database to a DB Machine is easy – but actually getting the benefits is harder. Before making the investment (a huge investment) in a DB Machine you will do a POC that shows that the applications work. That doesn’t mean they work as well as they could. Offload processing is more elusive than one might think, and to achieve it you may need to reconfigure your data structures and adjust your code. This is a non-trivial task that goes far beyond the usual SQL and segment tuning activities: it is a whole new layer of optimization.

We believe that the real ROI will come only from extensive work after the migration, as the application and the database are tuned to the capabilities of the Exadata platform. Yes, you will get an immediate performance boost – but you should be getting much more.

Let us help you optimize your applications for Exadata!

Contact us at 1-401-783-6172 or email us to see how we can help you.


Oracle Exadata Database Machine Tutorials
(Login Required for sessions 2 and above)

  1. About the Exadata Hardware
  2. What Makes the DB Machine Special
  3. Smart Scan in Theory
  4. How Smart Scan Functions – Demo
  5. Smart Scan in Practice
  6. Making Smart Scan Work – Demo
  7. HCC in Theory
  8. HCC performance and Compression Ratio – Demo
  9. HCC Limitations and Best Practices
  10. HCC Compression Degradation Issue – Demo
  11. Exadata is Good But Not Easy

Let us help you optimize your applications for Exadata! Contact us at 1-401-783-6172 or email us.

 

NOTE: Some corporate firewalls will not allow videos hosted by YouTube.


Transcript

HCC performance and Compression Ratio – Demo

Now, first off, for comparison, I’ll create a table which is not compressed at all. Then I’ll create a table which I’ll actually call CompHCC with the same structure, and for this table, I’ll use compress for archive high. That’s the highest level of hybrid columnar compression that we can do. It’s also of course the slowest and requires the most CPU usage. Just for comparison purposes, I’ll create a third table which uses the older mechanism of deduplication for compression.

Now, let’s just insert a couple of rows. I’ll enable timing so we can see if we do get any performance differences. Now, to get any compression at all, you must use the direct load. I’m deliberately using data that should be amenable to compression and also to deduplication so we can get some sensible comparisons.

How many rows? Well, let’s have, say, a million rows or even 100,000 rows. Now, I’ll copy those rows into my other tables, again being sure to use a direct load, set up the same length of times before and finally into my hybrid columnar compression table. We can see there’s a significant time penalty on this.

Now, I think it’s probably safe to assume that in the majority of cases, the extra delay for inserting into hybrid columnar compression tables – and remember I did choose the highest compression and therefore the worst performance – the delay is probably acceptable because in most environments, the loaded data is going to be in a synchronous or offline operation.

Let us just see how much space is actually being taken up. So first, my not-compressed table, then the deduplicated table and finally my HCC table, and there we see it. So the uncompressed data, 234 blocks; the deduplication, 150, okay; but the hybrid columnar compression table, down to seven. In that ratio, that’s worth about 30 to one. Of course, the data I chose is very amenable to compression, but particularly interesting is the comparison with deduplication because that data is perfect for deduplicating as well.

So we can see that hybrid columnar compression really does work.

×
Free Online Registration Required

The tutorial session you want to view requires your registering with us.

It’s fast and easy, and totally FREE.

And best of all, once you are registered, you’ll also have access to all the other 100’s of FREE Video Tutorials we offer!

 

×