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

About the Exadata Hardware

I don’t want to spend more than a few minutes talking about the hardware inside the Database Machine. There’s plenty of material that you can find that will give you full details of all of that.

So, in just a couple of minutes, just to set the scene for what’s going to come next, the Database Machine is a single box with vast amounts of CPU, memory, an astronomical amount of disk space and all the network bandwidth you might need. If the facilities of one machine are not enough for you, you can chain several together.

The hardware is designed so that it can withstand failure of virtually every component, virtually any components, and your database will remain open. One user shouldn’t know any difference. It’s particularly important to mention here that generally speaking, the machine is designed to continue operating at the same performance levels even if a component fails.

There is redundancy at virtually every point. There are one or two single points of failure. I wouldn’t worry too much about that. The box, it is only a single box, and there are limitations to what you can do with just one box. If you really must have 100% percent uptime under all circumstances, then you would need two Database Machines and typically use Data Guard to replicate between them.

Important to mention is a balance configuration. Oracle is going to a lot of trouble to make sure that all the components work together. You should not find, for example, that the disks can deliver data faster than the network can transmit it onwards. It’s configured out of the box – well, it is a box. Some people actually find this a bit annoying. You are not allowed to install any other hardware in the machine. I’m sure you could, but if you were to do so, it would take you out of the supported configuration.

There’s all sorts of facilities for *. There are quite a few * stories of some engineers turning up at a customer site and saying, “Hey, I’ve come to mend your Database Machine,” and the customer says, “Why? We haven’t noticed that there was anything wrong with it.” The old * machine could * if you link it up to My Oracle Support is pretty good. If there are grid control modules — by the way, if using grid control, there are grid control plug-ins for all the various components.

Now, that’s all very well, but it’s hardly unique. There are other boxes of similar capacity, and it’s worth mentioning at this point the Database Appliance. The Database Appliance is a similarly powerful and similarly well-balanced machine. So what distinguishes the Database Machine from anything else is the software that you run on 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!

 

×