Oracle Stream Analytics (OSA): the new Oracle Stream Explorer

A few days ago, Oracle released the new version of Oracle Stream Explorer and renamed it to Oracle Stream Analytics (OSA). This new version is an impressive release with over 15 new major features! It really deserves the name change.

Enhanced Patterns Library

The existing patterns have been enhanced substantially  now including Spatial, Statistical, General industry and Anomaly detection through streaming machine learning.


New Geo-spatial pattern

This pattern can be used to analyze streams containing (more...)

E-rows / A-rows

A recent post on the OTN database forum reminded me how easy it is to forget to keep repeating a piece of information after the first couple of hundred times you’ve explained it. No matter how “intuitively obvious” it is for one person, it’s new to someone else.

Here’s an execution plan that raised the question that prompted this note – it comes from calling dbms_xplan.display_cursor() with the ‘allstats last’ format option after enabling (more...)

EM13c- Applying System Patches with the OMS Patcher

The OMS Patcher is a newer patching mechanism for the OMS specifically, (I know, the name kind of gave it away…)  Although there are a number of similarities to Oracle’s infamous OPatch, I’ve been spending a lot of time on OTN’s support forums and via email, assisting folks as they apply the first system patch to  Admit it, we know how much you (more...)

Star Transformation in 11gR2

Star Transformation in 11gR2

 In the article we will review the prerequisites for the CBO to perform a star query transformation. We will use the SH samples schema. We will look at two cases with and without a bit map join index.

  1. Star transformation without a bitmap join index.
  2. Star transformation with a bitmap join index.

The prerequisites are as follows.


  1. Make sure that the primary and foreign keys are enabled.




#AIOUG #OTNYathra – A note of thanks

Folks, OTNYathra, the OTN tour organized by AIOUG got over last week. Thanks to the Team AIOUG for putting in loads of efforts to make this event a grand success. A round of applause to Sai, Hari, and Veera for coordinating it so well. This was my second OTNYathra and I could easily sense the penetration AIOUG has … Continue reading

SQL Riddle: Find the Sum of ASCII Codes of Employee Names (solution)

Zahar Hilkevich (from the blog – – cool blog, you should check it out) posted a riddle on Facebook.
The question was:

“For every employee find the sum of ASCII codes of all the characters in their names. Write a single SELECT statement only.”

----- ---------- ----------
 7788 SCOTT             397
 7876 ADAMS             358
 7566 JONES             383
 7499 ALLEN             364
 7521 WARD              302
 7934 MILLER            453
 7902 FORD              299

Oracle Data Visualisation Desktop : Enabling Advanced Analytics (R)

Oracle Data Visualization comes with all the typical features you have with Visual Analyzer that is part of BICS, DVCS and OBIEE.

An additional install you may want to do is to install the R language for Oracle Data Visualization Desktop. This is required to enable the Advanced Analytics feature of the tool.


After installing Data Visualisation Desktop when you open the Advanced Analytics section and try to add one of the Advanced Analytics graphing (more...)

Can I apply a BP on top of a PSU? Or vice versa?

Can I apply a Bundle Patch on top of a Patch Set Update?  This question was in my inbox this morning raised by a customer via a colleague.Our feeling said: Yes, but you'll have to deinstall the PSU first before applying the BP. Having a feeling is one thing, knowing the truth is better. And as I have so much... [Read More]

Oracle’s New Data Visualization Desktop

A recent addition to the Oracle lineup of visualization tools is the Oracle Data Visualization Desktop. Described by Oracle as a “single user desktop application that provides Oracle Data Visualization functionality to business users,” ODVD is an easy-to-install data visualization tool for Windows 7, 8 or 10 that packs some very powerful features.

I recently had a chance to sit down and explore ODVD and wanted to share some of my first impressions.

At its (more...)


The OTN database forum supplied a little puzzle a few days ago – starting with the old, old, question: “Why is the plan with the higher cost taking less time to run?”

The standard (usually correct) answer to this question is that the optimizer doesn’t know all it needs to know to predict what’s going to happen, and even if it had perfect information about your data the model used isn’t perfect anyway. This (more...)

Video : Flashback Table

Today’s video gives a quick run through of flashback table.

If you prefer to read articles, rather than watch videos, you might be interested in these.

The clip in today’s video comes courtesy of Deiby Gómez, an Oracle ACE Director, (more...)

#GoldenGate #Cloud Service (#GGCS) … what to expect?

As I sit here working on performing some GoldenGate migrations to AWS for a client, I’ve been thinking about the glimpse of GoldenGate Cloud Service (GGCS) that was provided to me earlier this week. That glimpse has helped me define what and how GGCS is going to work within the Oracle Cloud space. Ever since this service was announced back at Oracle Open World 2015, I’ve been wanting to get my hands on this cloud (more...)

Getting a C++11 compiler for Node 4, 5 and 6 on Oracle Linux 6

| May 1, 2016
A newer compiler is needed on Oracle Linux 6 when you want to use add-ons like node-oracledb with Node 4 or later. This is because add-ons for those versions need to be built with a C++11 compatibile compiler. The default compiler on OL 6 doesn't have this support. OL 7 does have such a compiler, so these... [Read More]

RMAN no files found to be unknown to the database error

Here’s a weird error message for my collection…

I’ve been working with a customer to setup a RMAN backup on his standby database (backup is going to SBT). After a while, we decided that we couldn’t avoid using the RMAN catalog so we created one.
Now, when using the catalog, we can backup the database from either the primary or standby instances and that will register to a shared catalog so we could restore from (more...)

When SQLT is not enough

A SQLT report has all kinds of pertinent information including—to name just a few—optimizer settings, indexes, statistics, plan history, and view definitions. However, sometimes a SQLT report is not enough to solve a SQL performance problem.(read more)

TROUG Days 2016 İstanbul Twitter Statistics

TROUG Days İstanbul was held last week (April 28th to 29th) at İstanbul Technical University Technopark. I think we used social media, specially twitter very effective, so I wanted to publish some twitter statistics about the event like I did for OUGN Spring Event. The statistics cover the period between April 27 and April 30.

Before sharing the twitter statistics, I would like to write a few words about the event. I feel very proud (more...)

Oracle Data Visualization Desktop – now available

After a bit of a long wait Oracle have finally release Oracle Data Visualization for the desktop. The desktop version of this tool is only available for Windows desktops at the moment. I'm sure Oracle will be bringing out versions of other OS soon (I hope).

To get you hands on the Oracle Data Visualization to to the following OTN webpage (click on this image)


After downloading has finished, you can run the installer.

When (more...)

How is data modeled in NoSQL?

The important thing to understand is the data does not change just because it is managed differently. If the data does not change, then the entities and the relationships contained in the data cannot change either. The entities and the relationships between them have not changed since the dawn of time. They were the same in the days of network database management systems which came before relational database management systems, they stayed the same when (more...)

Why should Oracle Database professionals care about NoSQL and where to start?

Oracle Corporation openly admits that NoSQL database management systems have the performance advantage over relational database management systems “when data access is ‘simple’ in nature and application demands exceed the volume or latency capability of traditional data management solutions.” Database professionals should therefore look seriously at NoSQL technology.(read more)

VirtualBox 5.0.20

It’s been 10-ish days since VirtualBox 5.0.18 was released and the world is screaming out, “Where is 5.0.20 already? We want to update all out Guest Additions!” Well, it’s here… 🙂

The downloads and changelog are in the usual places.

Happy upgrading!



VirtualBox 5.0.20 was first posted on April 29, 2016 at 2:32 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for (more...)