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.

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...)

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...)

Oracle Podcasts – Beer & Pizza

We have been fortunate enough to participate an ArchDev podcast about meetups –

The podcast talks about the differences between the meet-ups and events such as conferences, what we try to get out of a meetup and the effort put into arranging them.

Form more info about the meetup I help organise checkout out

Twitter Analytics using Python – Part 3

This is my third (of five) post on using Python to process Twitter data.

Check out my all the posts in the series.

In this post I'll have a quick look at how to save the tweets you have download. By doing this allows you to access them at a later point and to perform more analysis. You have a few instances of saving the tweets. The first of these is to save them to (more...)

Free Oracle Learning Tools

This post is one of a series on what I learned while not at Kscope18.

Would you like to learn something from the Oracle technology stack?
Here's a slide probably in a bunch of Oracle employee decks.

I think this collection represents the commitment Oracle is making to the developer community, in part thanks to (more...)


We have had a number of interesting conversations of late about the transition from ICS to OIC and to spice the discussion whether it should be OIC or Autonomous OIC. The reality of the situation is that the transition between ICS and OIC is a relatively straight forward one using the export and import tooling. […]

The post ICS to OIC appeared first on Implementing Oracle Integration Cloud Service.

Oracle XE 18c and #OracleRAD

This post is one of a series on what I learned while not at Kscope18.

Oracle XE (Express Edition) 18c - which is more than just a free, limited db.
Combined with the notion of #OracleRAD, you've got a mongo killer ;p


Quite a few people had a shot of the XE 18c feature list.

Oracle Code – Capgemini Blog

I have a new blog post over on the Capgemini site – talks about the way Oracle has changed its engagement towards developers and the Oracle Code London event that I presented at – first mentioned at Oracle Code London – Presentation & Periscope Interview



In a recent ODC thread someone had a piece of SQL that was calling dbms_random.string(‘U’,20) to generate random values for a table of 100,000,000 rows. The thread was about how to handle the ORA-30009 error (not enough memory for operation) that is almost inevitable when you use the “select from dual connect by level <= n” strategy for generating very large numbers of rows, but this example of calling dbms_random.string() so (more...)

nlOUG Tech Experience 2018 : The Journey Home

The trip home from nlOUG Tech Experience 2018 started pretty early, so true to form I didn’t sleep properly, for fear of sleeping through my alarm. At about 04:00 I was in the bath watching YouTube videos. 🙁

A couple of hours later I was at the station in Amersfoort waiting for the train to the airport where I was joined by Sabine Heimsath. Pretty soon we were on the train, where I made use of (more...)

nlOUG Tech Experience 2018 : Day 2

I had a rough start to day 2 of nlOUG Tech Experience 2018. The night before I was in bed and foolishly checked my email only to find some problems at work. I got out of bed, logged in and was checking out the impact of a storage fault. Some databases had been down and some app servers weren’t exactly happy. It was some time after midnight when things started to stabilise out. That meant (more...)

Massive Delete

The question of how to delete 25 million rows from a table of one billion came up on the ODC database forum recently. With changes in the numbers of rows involved it’s a question that keeps coming back and I wrote a short series for AllthingsOracle a couple of years ago that discusses the issue. This is note is just a catalogue of links to the articles:

nlOUG Tech Experience 2018 : Day 1

Day 1 of nlOUG Tech Experience 2018 started with me missing the opening keynote to spend time talking with Frits Hoogland about all things Vagrant, Ansible and Docker…

The first session I went to was Penny Avril & Dominic Giles with “What’s New from Oracle Database Development”. This was a quick run through some of the key features that have been introduced in 12.2 and 18c, which sets the scene well for some of (more...)

nlOUG Tech Experience 2018 : The Journey Begins

The trip to nlOUG Tech Experience 2018 started at a pretty normal time. I left the house at 08:00, which was far too early really, but you never know about the traffic when you are in rush hour, so I thought it better to be safe than sorry. Rather than the normal 30 minutes, it took about an hour to get to the airport, but once there I breezed through security and had a full (more...)

Oracle SOAR ?!

Larry Ellison announced yesterday Oracle SOAR:

Soar []:  
Fly or rise high in the air.
‘the bird spread its wings and soared into the air’
It is about migrating into the cloud [press release]:
the world’s first automated enterprise cloud application upgrade product that will enable Oracle customers to reduce the time and cost of cloud migration by up to 30 percent. By providing a complete set of (more...)

Time is Gold

So many have asked me when I’m starting at Microsoft and the official date is Monday, June 11th now.  Many also wonder what my upper limits are on how much I can handle, well folks, it looks like we’ve reached them!

I was supposed to start this last Monday, but as my last day approached, it became all the more clear that there was a need to change my ending and start date.  Individual deadlines (more...)

Sneak Preview of Newsfeed UX

I've recently have a chance to get deeply involved with a new User Experience ("UX") rolling out in Oracle HCM Cloud 18B, due out later this year.  We're rolling out some pretty cool work.  I like it for a few reasons:

  1. A fully responsive user interface - one code line that responds that provides the optimal UI for laptop/desktop, tablet and phone.
  2. More emphasis on Quick Actions, giving users shortcuts directly to transactional pages rather (more...)

How to Flush Single SQL Plan out of Shared Pool in Oracle

Todays let ‘s have look at the query which we use to resolve this issue ” How to Flush Single SQL Plan out of Shared Pool”. 



Find the address and the hash value

SQL> select ADDRESS, HASH_VALUE from V$SQLAREA where SQL_ID='495fdyn7cd34r';


---------------- ----------

00000005ODJD9BC0 247122679

Execute the purge procedure

SQL> exec DBMS_SHARED_POOL.PURGE ('00000005ODJD9BC0,247122679','C');

PL/SQL procedure successfully completed.

Thank you for giving your valuable time to read the above information.


Check Materialize View Refresh Schedule in Oracle

This post is about the view which we use in Oracle.

What is  Materialize View?

The view which we use to make a replica of a target master from a single point in a time is known materialize view.

As we know why do we need materialized view in Oracle?

  • redesign the system and eliminate those “tough” queries
  • cache the results of such queries
  • using materialized views.

Let’s have a look at the query which we use (more...)