Skip to main content

Oracle Open World -- Day Three

Best Practices for Implementing Database as a Service
This was not a best practices conversation, but something else. I was disappointed by this presentation and left early.

Cloning and Snapshots with Oracle Database 12c
Much has been talked about regarding the new features in 12c, including the multi-tenant option and now the new cloning features. First of all, multi-tenant / pluggable databases look like a game changing technology for the next couple years.

The cloning and snapshots really are the same things they always are. The differences introduced in 11g and 12c allow for the the DBA to have more control over the creation of clones and snapshots by leveraging the underling SAN technology. Yes, you heard that correctly: you can use database functionality to take a NFS snap. This is supported by an NFS client that comes as part of delivered functionality.

Data Modeling 101: Oracle SQL Developer Data Modeler
This was an hands on lab which allowed users to walk through several case studies for creating, maintaining, data models.

During this lab, we were able to watch the final race in the America's Cup. USA! USA!

Optimizer Statistics: A Fresh Approach
@connor_mc_d is a great speaker, with an engaging speaking and presentation style. A nice mix of humor along with some key bits of information regarding how to best engage the optimizer with statistics and histograms. While some of this was a re-hash of the presentation yesterday with @SQLMaria and @JLOracle.

So what did they all agree on? Don't collect statistics, unless you need to. Watch your statistics to make sure they are accurate. Same things for histograms.

Oracle Developer Cloud Service: An Introduction
Skipped this one in order to eat dinner before the event.

I watched Maroon5 at the Appreciation Event after dinner. Good energy, solid vocals and instrumentation. I was more impressed than I thought I'd be. It's been a long week, so I skipped out on the Black Keys.


Comments