It’s nearly Christmas!!

What’s the best Christmas Present?

A broken drum – you can’t beat it.

Merry Christmas everybody – have a great time and see you in the New Year with some more great blogs to read!

Blogs of the week

1.Date Format Handling in Oracle JET

Andrejus Baranovskis shares his thoughts on how to work with dates in Oracle JET application.

2. Oracle CX – act upon a negative customer experience

Johan Louwers says, “The challenge companies are facing is that it becomes more and more important to ensure the entire customer experience and the customer journey is perfect and at the same time an emotional binding is created. As a large part of the customer journey is being moved to the digital world a good digital customer journey is becoming vital for ensuring success for your brand.”

3. WITH and the MATERIALIZE hint in the cloud or not

Ric Van Dyke shared, “Recently in class a student mentioned that she’d be told that for the WITH clause you don’t need to use the MATERIALIZE hint anymore.  Maybe.   It turns out that if you REALLY want the subquery factor to be materialized, you do need to use it. ”

4. A dozen things to do with Oracle APEX

Scott Wesley shares his presentation “A dozen things to do with Oracle APEX”

5. Oracle Machine Learning notebooks

Brendan Tierney links to two of his previous blog posts, (this one and this one) and he looks at Oracle Machine Learning notebooks, some of the example notebooks and then how to create a new one.

6. Managing Snowflake Data Warehouse Compute in OBIEE

Mike Fuller says, “Congratulations! You just configured Oracle Business Intelligence Enterprise Edition (OBIEE) to connect to your freshly loaded Snowflake Data Warehouse instance and you’re feeling pretty good. Maybe your OBIEE dashboards are finally meeting SLAs, you’re not sitting with a DBA trying to tune SQL statements, your data is finally all in one spot, or maybe you’re just really looking forward to driving out into a field and going all Office Space on that database hardware you won’t be needing any longer. All of these circumstances call for a celebration.”

7. OAC Extending Dimensional Attributes by Blending Data

Angie Brown says, “Blending Data in Oracle Analytics Cloud allows us to share additional dimensions or measures from one data set with those from another, without having to do complicated metadata modeling using RPD functionality. This is a great feature for user-sourced categorizations and can empower users to utilize Data Visualization instead of forcing them to export into desktop tools such as Excel.”

8. UKOUG Oracle Conferences – why bother?

Neil Chandler tells us why we should bother.

9. Data Types of Join Columns

Dani Schnider writes, “A common approach in Data Vault is the usage of hash keys for primary and foreign keys. My customer uses MD5 hash values. The 128 bits are stored as a hexadecimal string in columns of data type CHAR(32). My recommendation is to use the data type RAW(16) instead. This not only reduces the amount of disk space to store the data, but has an impact on the performance of large joins.”

10. “The Best Laid Plans…”

David Fitzjarrell begins by saying:

“Oracle version 12 introduced the hybrid histogram as a performance improvement — such histograms are based on some ‘rules’ set forth in version 12.1. Those ‘rules’ are:

1) a value should not be found in more than one bucket

2) the bucket size is allowed to be extended in order to contain all instances of the same distinct value

3) adjusted bucket size cannot be less than the original size (not applicable at either end of the data set)

4) the original number of buckets should not be reduced

This type of histogram was a major improvement over previous histograms.”


This week on Twitter

UKOUG shared a link to the photos from the Conferences and Exhibitions

Steven Feuerstein tweeted a link to Chris Saxon’s database design quiz

Stories from and

Videos such as:

How to Migrate PBCS/EPBCS from Test to Production

12c Release 2 – Complete Reliability Option