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
Andrejus Baranovskis shares his thoughts on how to work with dates in Oracle JET application.
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.”
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. ”
Scott Wesley shares his presentation “A dozen things to do with Oracle APEX”
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.”
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.”
Neil Chandler tells us why we should bother.
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.”
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
Videos such as:
How to Migrate PBCS/EPBCS from Test to Production
12c Release 2 – Complete Reliability Option