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.


Exadata is Good But Not Easy

I don’t want you to think that I would ever criticize Exadata and the Database Machine. It is, I believe, a truly fantastic platform. The scalability and reliability are superb that should allow you to conform to any service level agreement, any requirements that you are ever likely to have, and certainly the performance you can get from the Database Machine platform can be astronomical compared to any other platform. No other platform has the intelligence built into the storage tier that the Database Machine has.

But things to think about: Before making the investment in the Database Machine, you will undoubtedly go through a proof-of-concept exercise, but what’s that actually going to prove? It will have proved nothing more than that your software applications do actually work. It will have gone no further than that.

Yes, there may have been an immediate performance boost, and there certainly should be after any sort of platform migration, but that initial performance boost is nothing to the performance boost you should be getting. The real benefits, however, may well require a lot of effort to obtain.

All those wonderful features – I’ve just looked at two of them, Smart Scan and hybrid columnar compression – but all of the other features, such as storage indexes, the use of the Smart Flash Cache, the benefits these can deliver can be quite elusive, and a lot of long-term monitoring and tuning will be needed.

There may be hundreds, possibly even thousands, of SQLs that have to be looked at to see if they really are exploiting the platform, the capabilities of the Database Machine, and getting this full return on investment, it is hard work. It’s going to take a long time. There are no wizards. You can’t go click, click, click and suddenly expect the benefits to come in. It’s a lot of hard work that requires time and skill.

I don’t want to frighten you off from this, because we can help.

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!