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 in Theory

Hybrid columnar compression is one of the more powerful capabilities of the Exadata storage platform. I should mention, by the way, that we can also enable it for you on ZFS* and pillar storage, but originally it was designed for Exadata.

Why is it so powerful? Well, in comparison to Oracle’s previous compression options, hybrid columnar compression really does compress. Everything Oracle issued previously didn’t compress at all. It did deduplication.

ACC is real compression and it comes with a choice of algorithms. You can choose which algorithm you wish according to the amount of CPU required, the time it takes to compress and of course the compression ratio you will get at the end of the operation. The compression ratios can indeed be excellent.

Experience shows that virtually all data will be compressed by at least five or six times. I’ve never seen worse than three times. Twenty times or30 times is, in fact, achievable, is realistic to expect on some OLTP type data.

Performance is of course important. The compression workload itself should have no effect whatsoever on the compute nodes because all the compression is done by the cell nodes. Indeed, performance may well often improve because experience shows that it’s far quicker to read a small amount of data from disk and decompress in memory than to read or write the uncompressed data to and from disk.

On the compute node, the optimizer does know what’s going on. The statistics on the objects will tell the optimizer how many rows are going to be retrieved by a single disk read and it will therefore make appropriate use of full table scans and perhaps move away from indexes.

So that’s the theory. Now let’s see what we can actually achieve and how we do it.

×
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!

 

×