Some new blogs to read!

Q. Why aren’t dogs good dancers?

A. Because they have two left feet!

We are well into the swing of 2019 now and starting to see some beginning signs of Spring and benefit from some milder (warmer, dare we say it) weather.

Come and read some of the new blogs that have been written of late.

Blogs of the week

  1. 2019 – Oracle Open World : London

Debra Lilley shares her experiences of Open World 2019.

2. EPM Cloud – New REST APIs to manage and optimise application performance

John Goodwin writes, “The 19.02 EPM Cloud release brings new REST API resources to set the administration mode of an application and assist with possible optimisation of an application.

The following is now possible through the REST API:

  • Set administration mode for an application.
  • Perform a full restructure of a block storage cube to eliminate or reduce fragmentation.
  • Compact the outline file of an aggregate storage cube.
  • Merge incremental data slices of an aggregate storage cube to improve performance.
  • Optimise aggregation to improve the performance of aggregate storage cubes.

Currently these are only available with the REST API, but I would expect the functionality to be added to EPM Automate in the near future.”

3. How to Hide & Show a region’s TIMING during development

Jorge Rimblas writes, “You may be familiar with the handy Substitution String #TIMING# in Oracle Application Express. When you add it to the footer (or header) of a region you get to see how long it took to run. It’s pretty nice, but you may not want to display that value all the time. It’s sure nice during development. So why not make it optional? Or toggle it on or off?”

4. Oracle 19c Available for Exadata On-Premises

Alfredo Krieg says, “Oracle just released Oracle 19c for Exadata On-Premises. This is just close to a year when they released the 18c version for Exadata On-Premises on February 16th 2018. If they follow the same schedule, we may expect 19c for the Database Cloud Service early next month!”

5. Connecting Oracle Analytics Cloud Essbase to the Autonomous Data Warehouse

Dayne Carley says, “This post is a step-by-step guide to creating the connections. Links to documentation are provided for all steps where possible. Screen shots are provided for the ADW Connection steps.”

6. Oracle USER vs sys_context

Scott Wesley writes, “This post was inspired by the fact I couldn’t find many good references for what I thought was ‘previously discovered truth’. So what does any good science-nut do? Add their own contribution. So here are two simple performance suggestions. The second was an added bonus I realised I could demonstrate simply.”

Read the full blog for his suggestions.

7. ORA-22905 when calling ODCI Table functions from PL/SQL

Kim Berg Hansen wrote, “Back in 2015 I experimented using ODCITable* functions to dynamically parse delimited text (see blog post here.)  Now blog reader Daniel Cabanillas points out, that it raises an error when used in PL/SQL. Silly me – I had only tried it out in SQL (my favorite language) and had completely missed that it failed in PL/SQL. Lucky for me, the classic workaround of dynamic SQL works here too!”

8. Ethics in the AI, Machine Learning, Data Science, etc Era

Brendan Tierney begins by saying, “Ethics is one of those topics that everyone has a slightly different definition or view of what it means. The Oxford english dictionary defines ethics as, ‘Moral principles that govern a person’s behaviour or the conducting of an activity‘. As you can imagine this topic can be difficult to discuss and has many, many different aspects.”

He concludes with, “The technology exists to make this kind of Location Based Marketing possible. This will be an increasing ethical consideration over the coming years for those who work in the area of AI, Machine Learning, Data Science, etc.  Just because we can, doesn’t mean we should!”

9. Why I Don’t Like ANSI Joins

Liron Amitzi shared, “Since Oracle started supporting ANSI joins in 9i, the Oracle community was divided into two groups: one loved it and tried to convince everyone to use it, and the other hated it and has never switched. As you probably understand from the title, I’m in the second group, and this is why.”

10. Data Collecting for Snowflake

Mike Fuller posts, “As of January 16, 2019, StreamSets Data Collector (SDC) Version 3.7.0 and greater now includes a Snowflake Data Warehouse destination, an optimized and fully supported stage to load data into Snowflake. The addition of a dedicated Snowflake destination simplifies configuration which expedites development and opens the door for getting the most out of your SDC+Snowflake integration.”

This week on Twitter

Carsten Czarski tweeted Forms in APEX 19.1: More power, more Flexibility

Shiva Molabanti shared Data Warehouse and Visualizations for Credit Risk Analysis

UKOUG post a Call for Content Deadline for #OUGScotland19 is 4th March

Stories from and

Videos such as:

IT Wars: Developer vs. DBA or How to Get What You Want and Need

and Hints and Tips: A silent movie on joins