My Next Book: Oracle Database 12c Release 2 Testing Tools and Techniques for Performance Stability

I am excited to announce the pre-release of my third co-authored book in as many years: Oracle Database 12c Release 2 Testing Tools and Techniques for Performance Stability.

My extremely talented and loquacious co-authors include database performance benchmarking expert and Oracle ACE Dr. Bert Scalzo,  and Oracle ACE Director Deiby Gomez, the youngest Oracle ACE in the world. We are leveraging our combined years of experience working with Oracle Databases to provide a new look at the testing tools that are built into Oracle Enterprise Edition.

Our book will be looking closely at the myriad different tools available for Oracle 12cR2 SQL performance tuning techniques, but we’ll also be diving deeply into the rich feature sets of Real Application Testing Suite and Database In-Memory. We’re also focusing our efforts on getting everyone ready to tune application workload performance in an Oracle Cloud environment; we have actively leveraged the same environments that any Oracle DBA can use on either a free or subscription basis to prove out techniques that measure the impacts of switching from on-premises hardware to Cloud-based data centers.

Our book won’t be available until just before Oracle OpenWorld 2017, but you can pre-order it via or just stay posted on its release date here. And while you’re at it, be sure to check two other books that I’ve co-authored, Oracle Database Upgrade, Migration & Transformation Tips & Techniques from Oracle Press, and Oracle Database Problem Solving and Troubleshooting Handbook. All three of these books are available in either soft-cover and Kindle format.

Oceans 17: Heist Some Knowledge At C17LV In Vegas

c17lvThe days are getting longer, the evening shadows shorter, and that can mean only one thing: it’s almost time for COLLABORATE17! IOUG will be hosting over 5,000 IT professionals from every corner of the earth for one of the best Oracle conferences of 2017 on April 2 – 6 in Las Vegas at the Mandalay Bay Resort.

Last year’s event was the best I’ve ever attended, so my expectations for this year are even higher – especially with the recent announcement of Oracle Database 12cR2’s general availability. Like any good movie about heists, there will be a resolute cast of characters who overcome every technical challenge that’s thrown in their way … and this year, that’s us, your humble team of presenters. My four sessions at C17LV are focused on several new features of 12cR2, so if you’re struggling to get your head around what the latest release will mean for your IT organization, be sure not to miss any of them. And don’t forget to attend the 12c Database SIG meeting as well, which I’ll be overseeing alongside my able colleague and ACE Director Anuj Mohan – more on that in a later post.

Oracle 12cR2 Database In-Memory: Adventures with SwingBench TPC-DS

Monday, April 3 2:45 PM – 3:45 PM

Palm C

Session# 368

For the past year, I’ve been working closely with Dominic Giles, the original author of Swingbench, to bring to fruition a new version of that venerable benchmark generator tool that now includes the ability to generate a simulated TPC-DS workload. We’ll harvest the fruits of our labor during this session as I demonstrate several aspects of Oracle Database 12cR2’s newest Database In-Memory features, including In-Memory Expressions, ILM ADO Policies for In-Memory Objects, and improvements to In-Memory Joins. This session offers a great way to dive into the deep end of the 12cR2 pool, so be sure to mark this one on your calendar.

Stop Guessing, Start Analyzing: New Analytic View Features in Oracle Database 12cR2

Tuesday, April 4 11:00 AM – 12:00 PM

Palm A

Session # 369

If you’re either an Oracle DBA or an applications developer who works with data warehouses, you already know that answering complex business questions often require building extremely complex, n-dimensional queries against fact tables and dimensions stored within Oracle databases. Often, the toughest aspects of any business intelligence endeavors involve establishing accurate business rules about the relationships between data. What if there was an easier way? Fortunately, Oracle 12cR2 offers a brand-new answer: Analytic Views, an entirely new set of database objects aimed at making short work of these analytical tasks. If you attend this session, be prepared to leave with practical examples of how to leverage these powerful new features.

Cloud DBA Transformation: Futuristic TomorrowLand, or Desolate Wasteland?

Tuesday, April 4 4:15 PM – 5:15 PM

Banyan C

Session # 196

Unless you’ve been trapped under a rock for the past 18 months, you must have already heard all about Oracle Cloud and its many possible configurations – Public, Private, or Hybrid and the wonderful joy and happiness it will bring to the civilized world. But if you’re an Oracle DBA, you may have more of a jaundiced view about the implications of Oracle Cloud for your databases, your IT organization, and – perhaps most crucially – your career. Join me and my colleague Gary Gordheimer as we employ our unique self-deprecating style and distinctly different perspectives to probe what Oracle Cloud will mean in the immediate future from both utopian and dystopian viewpoints. Warning: There will be laughter – so be sure to bring a sense of humor.

Oracle 12cR2 Expert Panel

Wednesday, April 5 4:15 PM – 5:15 PM

Palm A

Session # 518

With the release of Oracle Database 12cR2 barely a few weeks before this session, the dozens of new features will be a daunting task for any Oracle DBA to navigate. So – don’t! Join me and a panel of experts – Oracle ACEs all! – as we review several key feature sets that we find most compelling for today’s DBAs, including the latest buzz on Multitenancy, Database In-Memory, Big Data, Sharding, and many others.


March 15th: DBAs, Start Your 12.2 Engines!

After what seems to me like an eternity, I’m excited to see Oracle has finally announced that Oracle Database 12.2 will at last be generally available as of March 15, 2017. This is subject to change, of course, so check MOSC Note 742060.1 for details.

To get yourself up to speed, be sure to take a look at my presentation (here in video form) on what I think are some of the most compelling features of 12.2. I hope that you find them interesting, enjoyable, and most of all informative – be sure to let me know if you have any questions.

On to 12.2! It’s going to be an interesting 2017. (But we already knew that, right?)

Join Me in Dallas for Hotsos Symposium 2017 on February 28

hotsossymposium2017_logoMy colleagues at Hotsos have humbled me again: I’ve been chosen once again to present at Hotsos Symposium – one of the most concentrated bunch of Oracle database performance tuning experts in North America – in Dallas, TX during the week of February 28, 2017.

For the first time ever, I’ll have two sessions at Hotsos. My first session – titled Oracle 12cR2 Database In-Memory: Adventures with SwingBench TPC-DS – will show how Oracle 12cR2’s latest Database In-Memory features can make a serious progressive impact on complex queries. It’ll also be the first time that I’ll publicly demonstrate the latest version of the venerable Swingbench utility which now offers the capability to simulate a scaleable version of of the TPC-DS benchmark against an Oracle database. I’ve been honored to work with Dominic Giles, Swingbench’s original author, to develop and extensively test this latest version of that tool since mid-2016.

My second sessionStop Guessing, Start Analyzing: New Analytic View Features in Oracle Database 12cR2 – will show you how to take advantage of a brand-new set of features that makes extremely short work of building complex analytic queries against fact and dimension tables with the creation of only a few simple database objects.

So if you are in the neighborhood of Dallas during the first week of March, please register and attend for this most excellent conference! I hope to see you there.

Is the Future of Oracle DBAs Cloudy, or Brighter Than Ever?


So you are your company’s newest (or oldest) Oracle DBA, and that means you’ve just finished getting back up to speed after the 2016 holiday season (which probably meant scads of patches and upgrades to your systems while everyone else was enjoying eggnog with their families). You’ve spent your spare time between crises to be ready to move to Oracle 12c Release 2 as soon as it’s out … and now your CIO and CTO are bugging you about moving everything to the Cloud to help reduce costs, and you’re still trying to figure out what the difference is between CAPEX and OPEX. It’s enough to make you wonder if your Oracle DBA role will still be around in 2017!

If this sounds even a little bit like your career today, then be sure not to miss my upcoming webinar on Wednesday, February 15, 2017 at 1:00 PM CST (2 PM EST, 11 AM PST). My presentation – DBA 2.0 Is Dead. Long Live DBA 3.0! – will present my vision for the future of the Oracle DBA role in 2017 and beyond.

Registration is free but filling up quickly. And don’t forget to send me some feedback on my forecast!

Chase Away The Winter Blues! Meet Me @ February 23rd COUG Winter Event

One of the best ways to stay warm in February in Chicago is to stand next to something really hot. So why not join me while I discuss some hot Oracle 12cR2 topics with your colleagues at the Chicago Oracle Users Group (COUG)? Our event sponsors, OnX Enterprise Solutions is our event sponsor for the COUG Winter Event at a convenient venue – the Chicago Marriott Naperville – close to the Western Chicago suburbs and easy to reach right after work. We’ll feast on gourmet pizza, salads, cookies, and of course something warm to drink to chase away the winter chill.

I’ll be presenting two Oracle Database topics:

  • DBA 2.0 Is Dead. Long Live DBA 3.0! will look at the changing role of the Oracle DBA in 2017, especially in light of a continually-shifting landscape that includes Cloud, Security, Big Data, IoT, and Reshoring.
  • Stop Guessing, Start Analyzing: New Analytic View Features in Oracle Database 12cR2 will show you how to take advantage of a completely new feature set – Analytic Views – in 12cR2 to build robust data warehousing models and obtain complex, n-dimensional results with only a few lines of code.

Be sure to register for this event as soon as possible, as space is quite limited. I look forward to seeing you all there!

Forestall Failure Before You Upgrade With Oracle 12cR1 RAT

TIOUG_Logohe second part of my two-part series entitled Regression Analyzed, Tout de Suite: Leveraging Oracle 12c Database Real Application Testing (RAT) Suite has just been published in IOUG SELECT Journal’s 4th Quarter 2016 edition. This part of the article series show how I leveraged RAT’s Database Replay features to evaluate Oracle Database’s Database In-Memory features. If you don’t have an IOUG membership, you can still browse a copy of my article in PDF format … but seriously, shouldn’t you become a member of one of the best Oracle User Groups in North America?