June 22nd in Chicago: Hot 12cR2 Topics On Tap

Summer in Chicago can be unpredictable, but our colleagues at the Chicago Oracle Users Group (COUG) are certain of one thing – it’s time to plan your transition to Oracle Database 12cR2 before winter arrives. So be sure to join us for a special Oracle-sponsored event on Thursday, June 22, 2017.

Oracle has graciously granted us access to an excellent guest speaker: Willie Hardy, Vice President of Oracle Database Product Management, will share his unique perspective on all things Oracle Database 12cR2 with his presentation, What’s New in Oracle Database 12c Release 2.

To round out our evening, I’ll be presenting one of my favorite Oracle Database topics, Oracle 12cR2 Database In-Memory: Adventures with SwingBench TPC-DS, a reprise of my presentation at our first-ever 12c SIG Virtual Seminar.

And we have a new venue as well – the Addison Hampton Inn & Suites – that’s central to the Western Chicago suburbs and easy to reach right after work. Be sure to join us – you can register for this free event here. I look forward to seeing you there!

May 9-10, Atlanta: Get Your Tech On, Courtesy of GAOUG!

If you are ready to find out more about Oracle 12cR2 – or if you’re even just worried about the future of Oracle DBA-dom – please mark May 9-10 on your calendar and plan to join me and an illustrious group of Oracle ACEs in Atlanta when the Georgia Oracle Users Group convenes their 2017 Tech Day conference.

My first presentation is DBA 3.0: Transform Yourself into a Cloud DBA, or Face a Stormy Future, will offer up my viewpoints on how five key trends in the IT industry – Cloud, Big Data, IoT, Security, and Reshoring – are having an impact on the role of the Oracle DBA within their IT organizations, and how it’s crucial to transform yourself into a Cloud DBA in 2017.

My second presentation, Stop Guessing, Start Analyzing: New Analytic View Features in Oracle Database 12cR2, will take a look at the unique features of Analytic Views in 12cR2 that can save an Oracle DBA and application developers from writing inordinately complex code to solve multi-dimensional analytic queries.

If you attended this event last year, you already know how much talent was on stage and the level of technical detail that was presented. Please tell your colleagues all about this event – it’s one of the best in the Southeastern US, and supported by an extremely robust Oracle User Group. So if you are planning to be in the Atlanta area during the 2nd week of May 2017, don’t miss this event!

If you want to learn more about GaOUG Tech Days and the other impressive speakers, check out the blog hop posts below. If you’ve never heard of a blog hop, it’s a group of bloggers who all get together to blog on a similar topic, giving you a lot of useful information from different perspectives, but in one stream. Enjoy your “hop” between blog posts and register for GaOUG Tech Days today!

Stewart Bryson, RedPill Analytics

Jim Czuprynski, OnX Enterprise Solutions

Chris Lawless, Dbvisit Software

Bobby Curtis, Oracle Corporation

Danny Bryant, Accenture Enkitec Group

Eric Helmer, Mercury Technology Group


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 Amazon.com 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!