Cursor_sharing force

Prompted by a recent ODC (OTN) question I’ve just written up an example of one case where setting the cursor_sharing parameter to force doesn’t work as you might expect. It’s a specific example of what I believe is a theme that can appear in several different circumstances: if your SQL mixes “genuine” bind variable with literals then the literals may not be substituted.

Here’s a simple data set to start with:

rem     Script:         cursor_sharing_limit. (more...)

The Forrester Wave™: Big Data Fabric, Q2 2018

The @Forrester Wave™: Big Data Fabric, Q2 2018. @Oracle continues to broaden its Big Data Fabric solution and leads the pack.

OSWatcher, Tracefile Analyzer, and Oracle RAC 12.2

When I started the series about Tracefile Analyzer (TFA) I promised three parts. One for single instance, another one for Oracle Restart and this one is going to be about Real Application Clusters. The previous two parts are published already, this is the final piece.

The environment

I am using a virtualised 2-node cluster named rac122pri with nodes rac122pri1{1,2} based on Oracle Linux 7.4. RAC is patched to I (more...)

Published: To New Beginnings and New Paths to Learning

I published To New Beginnings and New Paths to Learning on Medium.

Recommended: Connect to Snowflake with Node.js Driver

I recommended Connect to Snowflake with Node.js Driver on TysonRhame.

Oracle’s extended support – when is it free of charge

It’s such a simple, basic and old question I got from a colleague: “Do you have to pay for extended support?”.  And if so, how much I have to pay for it. So basic and yet… always have to check again  the waived support, what prices and where to find this information. It’s getting more important for Oracle Database 11g, which is at the end of the ‘waived’ support.

What kind of support (more...)

Last Week in Stream Processing & Analytics – 21.6.2018

This is the 118th edition of my blog series blog series around Stream Processing and Analytics!

As every week I was also updating the following two lists with the presentations/videos of the current week:

As usual, find below the new blog articles, presentations, videos and software releases from last week:

News and Blog Posts

Apache Kafka / Kafka Streams / Confluent Platform

JavaScript – Method to Call Backend Logic in Sequential Loop

When we call backend REST service from JavaScript - call by default is executed async. This means it will not wait until response from backend is received, but will continue executing code. This is expected and desired functionality in most of the cases. But it might be requirement, where you want to call backend in synchronised way. Example - calling backend service multiple times in the loop, next call must be invoked only after previous (more...)

Kscope18: It’s a Wrap!

Kscope18: It's a Wrap!

As announced few weeks back I represented Rittman Mead at ODTUG's Kscope18 hosted in the magnificent Walt Disney World Dolphin Resort. It's always hard to be credible when telling people you are going to Disneyworld for work but Kscope is a must-go event if you are in the Oracle landscape.

Kscope18: It's a Wrap!

In the Sunday symposium Oracle PMs share hints about the products latest capabilities and roadmaps, then three full days of presentations spanning from the traditional (more...)

Oracle Code : Paris

Just a quick note to say I’ll be speaking at Oracle Code : Paris in a little over two weeks.

I’ve only presented at the Paris Province Oracle Meetup, so this will be my first conference in France. 🙂

See you there!



Oracle Code : Paris was first posted on June 21, 2018 at 8:56 am.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If (more...)

preupgrade.jar version number

Mike Dietrich is very motivated to convince everyone who wants to take Oracle database upgrades serious to use always the latest version of preupgrade.jar.

Some parts of Note:884522.1 - How to Download and Run Oracle's Database Pre-Upgrade Utility
 are misleading in my point of view:
If the upgrade-to version is 12.2 or higher, then save the file to your target $ORACLE_HOME/rdbms/admin directory and then unzip the file. It could be your source (more...)

Error!?! What’s going in APEX? The easiest way to Debug and Trace an Oracle APEX session

There are some days you just can't explain the behaviour of the APEX Builder or your own APEX Application. Or you recognize this sentence of your end-user? "Hey, it doesn't work..."

In Oracle APEX 5.1 and 18.1, here's how you start to see in the land of the blinds :)

Logged in as a developer in APEX, go to Monitor Activity:

 From there go to Active Sessions:

You will see all active (more...)

Case Management and the Microprocess Architecture

In this article I introduce the concept of the Microprocesses Architecture which addresses some important limitations of traditional monolith Case Management applications.

In the Oracle Integration Cloud a Case Management application consists of at least one Dynamic Process that on its turn consists of Case Activities. A Case Activity is implemented by a (structured) Process, or a Human Task. The unit of deployment is an Application, which consists of one or more Dynamic Processes plus (more...)

Visualising Transfers on a Sankey Chart

Earlier this month I posted a method of getting a Doughnut Chart in HCM Cloud despite only the traditional pie chart being supported – with the cunning use of Google Charts, as first shown by Damien Roux and Julian Challenger.

Google Charts can do a lot more than just doughnuts though. Have a look at Gallery 1 and Gallery 2 for a broader range.

One that particularly caught my eye was the Sankey Chart, which I (more...)

Presenting at ODevCYatra 2018 in Hyderabad, Pune and Mumbai (11, 13 and 14 July)

I_M_SpeakingIn 2013 I have participated in the OTN Yatra – a conference tour of six cities in India (). This year I am glad to be back for a second Yatra. I will present in three cities (Hyderabad, Pune and Mumbai) and I am really looking forward to meeting many old friends and new ones as well.

I will present three different talks on these events:

  • Intro to Docker Containers and the Oracle Platform
  • The (more...)

Why Automation Matters : Patching and Upgrading

As I said in a recent post, you know you are meant to, but you don’t. Why not?

The reasons will vary a little depending on the tech you are using, but I’ll divide this answer into two specific parts. The patch/upgrade process itself and testing.

The Patch/Upgrade Process

I’ve lived through the bad old days of Oracle patching and upgrades and it was pretty horrific. In comparison things are a lot better these days, (more...)

The death of UTL_FILE

In a previous post I covered a technique to improve the performance of UTL_FILE, but concluded the post with a teaser: “you probably don’t need to use UTL_FILE ever again”.


Time for me to back that statement up with some concrete evidence.

UTL_FILE can read and write files. This blog post will cover the writing functionality of UTL_FILE and why I think you probably don’t need UTL_FILE for this. I’ll come back to UTL_FILE to (more...)

Using CFDOT (CF Diego Operator Toolkit) on Pivotal Cloud Foundry

I decided to use CFDOT (CF Diego Operator Toolkit) on my PCF 2.1 vSphere ENV today. Setting it up isn't required as it's installed out of the box on Bosh Managed Diego Cell as shown below. It gives nice detailed information around Cell Capacity and other useful metrics.

1. SSH into Ops Manager VM

pasapicella@pas-macbook:~/pivotal/PCF/APJ/PEZ-HaaS/haas-165$ ssh
Unauthorized use is strictly prohibited. All access and activity
is subject to logging and (more...)

When WHEN went faster

Yeah…try saying that blog post title 10 times in a row as fast as you can Smile

But since we’re talking about doing things fast, this is just a quick post about a conversation I had a twitter yesterday about the WHEN clause in a trigger.



That is an easy benchmark to whip up – I just need a couple of tables, each with a simple a trigger differing only by their usage of the (more...)

Power BI and the Speed(ier) Desktop

I can be an extremely impatient person about anything I think should be faster.

I’m diving in deep with Power BI and for most of the early on lessons, the data sources used are Excel and…ahem…Microsoft Access.  I don’t know a DBA alive that enjoys working with Access.  Its great for the common user to have a database application, but we can barely use the words “Access” and “Database” in the same (more...)