The latest reading material from this past week…

Why was the computer cold?
It left its Windows open!

Here’s the latest…

Blogs of the week

  1. What is Preview Versions for Autonomous Database

Julian Dontcheff writes, “A first preview is not exactly a pleasant experience for producers, directors and actors. In the IT world, it is exactly the opposite: DBAs can use the new version of the database before it becomes mainstream.”

He also links to the Oracle Documentation

2. ANSI Plans

Jonathan Lewis asks the question: Should the presence of an intermediate view name generated by the optimizer in the course of cost-based query transformation cause two plans, which are otherwise identical and do exactly the same thing, to have different plan hash values ?

3. Understanding the Value of Enterprise/Master Data Management for Financial Reporting

Kate Helmer begins with, “Today’s post is a little different than most – instead of focusing just on technical implementation details, let’s take a step back and think more conceptually about the “why” for implementing an enterprise data / master data management solution in the office of CFO / financial reporting.”

4. ODI Hidden Gems – Target Load Order

This one starts with, “Today’s gem is related to a very nice surprise that all ODI developers had when they were migrating from ODI 11 to ODI 12, which is the ability to load multiple target tables with the same ODI mapping object. You may have a very large mapping and “split” (with Split object) the result set into multiple targets, or you may just copy the same result to different target tables, mapping different fields in each of the targets. This post is not about what you can do when loading multiple targets (which is kind a lot due to this feature in ODI 12c), but how to control the order which those target tables are loaded.”

5. Oracle Grid Infrastructure vs. SLES 12

Marco Mischke writes, “During a new installation of an Oracle Grid Infrastructure 19.4 at a customer’s site, I experienced a strange behaviour. The databases could be started and stopped via SQL*Plus as usual. Also stopping of databases using “srvctl” was fine. But when it came to starting a database via “srvctl” or rebooting the nodes, I experienced trouble…”

6. Partition Pruning and NLS Setting

Dani Schnider says, “In a performance review for a new customer, I analyzed the partitioning strategy of their application. Several tables were partitioned, but for some of them, partition pruning didn’t work. I was confused at the beginning, but when I looked at the NLS settings of the application, I learned that the flexibility of National Language Support has an impact on the partitioning strategy. Actually, it is clear, but I wasn’t aware of that. In this blog post, I want to show what happens when linguistic and case-insensitive sort and comparison is enabled.”

7. How to prepare data for machine learning

Mike Hamer starts off by saying, “One of the most important steps in any machine learning project is the gathering, preparation, and cleaning of the data. Data is the backbone to your project and by spending the time and resources on this initial step you’ll be better positioned for success.”

8. Combining Advanced and Custom Filters in Looker

Kristi Smith writes, “I’m constantly impressed with the advanced filter functionality in Looker. It’s so convenient…and fairly intuitive, once you get the hang of the syntax. As always, if you run into an issue or need more context, Looker’s documentation is a great place to start.”

9. Top Big Data Analytics Trends Hold True As We Look Toward 2020

Lynda Partner starts her blog by writing, “The overall importance of data and information within organizations has continued to grow. We’ve also seen the continued rise of megatrends like IoT, big data – even too much data – and of course, machine learning. That’s along with the ongoing maturation of other, perhaps less known, but equally important data initiatives such as governance and integration in the cloud.”

10. All You Need to Know about Oracle Database Patching

Liron Amitzi says, “This is a topic I wrote about in the past (understanding Oracle patching and new version numbering). But now, after the new patching concept (since 12.2) and numbering change (since 18c) has been here for a while and has been stabilized, I think it’s time to summaries the new patching/versioning in a new post, so here it is…”

This week on Twitter

Philippe Lions shared the link to download Desktop version 5.4

Tim Hall posted #thanksOGB It’s a wrap

Connor McDonald shared:

Stories from and

Videos such as:

Maria Colgan: Autonomous Database for Developers

Getting started with Oracle APEX on Oracle Autonomous Database