A weekly round up

What did the traffic light say to the car?

Don’t look, I’m about to change

Groan. Read some of these blogs and watch some of these videos instead.

Blogs of the week

  1. Table Order

Jonathan Lewis begins his blog by saying, “Over the last few days I’ve highlighted on Twitter a couple of older posts showing how a change in the order that tables appear in the from clause could affect the execution plan of a query. In one case the note was purely theoretical describing a feature of the way the optimizer works with simple query blocks, in the other case the note was about an anomaly with table elimination that could appear with both “ANSI” and “traditional” Oracle syntax. Here’s another note that might be more generally useful – an example of an odd side effect of ordering and “ANSI” syntax, with a suggestion for a pattern for writing ANSI SQL.”

2. Ultimate, comprehensive review for big data warehousing for #OOW18

Keith Laker gives us THE ultimate, comprehensive review for big data warehousing for #OOW18. Download for iBooks, in PDF form or in Text format.

3. Key Features of EDMCS 18.10

This blog gives the highlights as:

  • New packaged adapter for Oracle Financials Cloud GL
  • Property Inheritance
  • Add Related Nodes Across Viewpoints
  • Download Viewpoint in Request Context
  • Request Load File Summary Statistics
  • Level Property
  • Metadata Deletion
  • Object Details Popup

4. ERROR: Invalid interpolation format for “command” option in service…

Robin Moffatt shows us some “funky Docker Compose stuff”!!

5. Ranges with NULLs 04: Pack, Merge

Stewart Ashton starts by saying, “In this post, I’m going to treat two closely related but distinct requirements:

  1. “Pack”: in a SELECT, return contiguous or overlapping ranges as one range.
  2. “Merge”: modify a table to reduce contiguous or overlapping ranges to one range.

These operations should take into account other data associated with each range: ranges are packed or merged only when the other data is the same.”

6. 10 possibilities and 10 restrictive things you might not know about UPDATE

Sven Weller opens by writing, “This is mostly about the UPDATE command. Features which I noticed, that many do not know about. Some are really useful, but most fall in the category of “interesting to know”.”

7. How Are My Users Connecting? Analyzing OAC and OBIEE entry points

Francesco Tisiot says, “Let me introduce you on how to monitor OAC/OBIEE connections via network sniffing and usage tracking in this new world of self-service BI platforms.”

He covers:

  • A Bit of History
  • Centralised BI Solutions
  • Self Service BI Platforms
  • A Mix of the Two
  • OBIEE as a datasource
  • Good for all use-cases
  • How can you monitor who is connecting?
  • Network Sniffing
  • Usage Tracking
  • Real Example
  • Set up
  • Querying and Checking the Logs
  • Automating the Tracking
  • Conclusion

8. Oracle SQL Developer Version 18.4 Sneak Peek

Jeff Smith writes about a bug and its clean up for 18.4.

He says, “For this version, it will just include bug fixes – no new features. So for Holiday Season, you can expect the most stable and reliable version of 18.”

9. Amazon SageMaker Model Endpoint Access from Oracle JET

Andrejus Baranovskis writes, “If you are implementing machine learning model with Amazon SageMaker, obviously you would want to know how to access trained model from the outside. There is good article posted on AWS Machine Learning Blog related to this topic – Call an Amazon SageMaker model endpoint using Amazon API Gateway and AWS Lambda. I went through described steps and implemented REST API for my own module. I went one step further and tested API call from JavaScript application implemented with Oracle JET JavaScript free and open source toolkit.”

10. Parallelizing Standard Edition Data Pump

Marco Mischke writes, “Today’s blog post is about Data Pump. Sometimes we use this tool to migrate applications to another database. There are some reasons for doing so, reorganizing data, difficult upgrade/migration paths to mention two. With the Enterprise Edition of the Oracle Database we can do the export and import in parallel. But what if we are using Standard Edition only? We are bound to export and import serially. This is a major restriction, especially if time is limited. But there is a way to make it run in parallel.”

11. ALTER TABLE ADD column with DEFAULT value and Virtual Private Database

Dirk Nachbar explores the following, “I recently came over a real strange behaviour with ALTER TABLE ADD column with DEFAULT value on one of my customers. They are using a Software Product based on WebLogic and Oracle Database, from time to time we receive some new version of this Software Product which includes Database related changes, e.g. add new tables, add columns to an existing table and so on. Within the latest Software Update, we could observe that the overall update process for the Database related part was increasing to around 12 hours !!!! Before it was quite shorter. Mainly the time was taken for ALTER TABLE ADD column with DEFAULT values. After some investigations, I could see, that a simple ALTER TABLE ADD column with DEFAULT values was resulting into single updates with the provided DEFAULT value instead of updating the metadata for the given DEFAULT value. According to the Oracle Documentation in such a case the provided DEFAULT value should only be metadata and not updated for each row.”

Read the entire blog for the reason/solution

12. Exadata Cloud at Customer — my experience & interesting stories — traditional methods vs Oracle Database Cloud Service Console

Erman Arslan writes, “Today, I want to share my experience on Exadata Cloud at Customer, aka ECC (or ECM 🙂 I want to share the things I have seen so far… ( I have 3 on-going ECC migrations at the moment). Rather than giving the benefits about this machine ( I already did that) and this Cloud@customer named cloud model, I will concentrate on explaining the database deployment and patching lifecyle.”

This week on Twitter

Jonathan Lewis tweets his Public Appearances Schedule

ODTUG reminds us of the Kscope19 abstract deadline

Markus Winand tweeted a link to the blog What’s New in Oracle Database 18c

Paper.li

Stories from performancearchitects.comwww.us-analytics.com and www.thatjeffsmith.com

Videos such as:

Hints and Tips for 18c documentation

BI Connector: Connecting Tableau to Oracle BI