Haters gonna hate!

angry-1300616_640I read Debra’s post this morning and the fact she had to write it was pretty disappointing. I realise there will always be haters out there who find fault with what people in the community do, but even so…

I’ve written about this in the past (here and here). As Debra pointed out, I’ve got a YouTube series called My Glamorous Life, which illustrates just how boring life on the road is most of (more...)

Oracle Segment Fails

The instance that I’ve built for my students in a Fedora VM is quite stable except for one feature. The feature is the hibernation process of the base operating system. Sometimes when the base operating system hibernates, it causes the Oracle shared memory segment to fail. When that happens you get the following error:

ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Process  (more...)

Running external programs from the scheduler

Although I normally use the job or scheduler facility to run database-centric style processes, most commonly PL/SQL programs, there is nothing to stop you from using the scheduler to gain control over tasks that might normally need to be done outside of the database.  And of course, in the world of virtualization, cloud and other such innovations, the ability to initiate and perform tasks from within the database becomes increasingly useful, since often access (more...)

Oracle Database Cloud (DBaaS) Performance Consistency – Part 5

This is the fifth part of this installment, and before coming to comparisons to other cloud providers, in this part I show the results of the read-only test that I've already described in part three of this series, but repeated at a later point in time. The test setup was identical and can be checked in the mentioned previous part.

The reason for running the test again was the fact that I was informed during (more...)

Why I Moved from CompleteITProfessional to DatabaseStar

Complete IT Professional has been renamed and rebranded to Database Star. I’ll explain what that means and why I made this change in this article. What Was The Change? You’re probably reading this on the new DatabaseStar.com website, wondering why you’re here instead of on CompleteITProfessional.com. Well, the reason is that I have decided to […]

My Rock Star Life

I recently posted about not going on the APAC OTN Tour. My motivation for doing so was to explain just once, why not, hopefully to crush the rumours and debate as to why.

Actually for my UK friends, it was a bit like Will Young leaving Strictly Come Dancing, if you don't say why, people simply make up their own mind.

Anyway, I posted the blog and received great messages of support both publicly (more...)

EM13c: Is It Possible to Delete a Job Run with EMCLI?

Enterprise Manager Cloud Control provides a centralized job scheduling system and it’s possible to control it through both web interface and EMCLI. On the other hand, it seems web interface provides more control over the past jobs, for example it’s not possible to delete a job run with EMCLI, while it’s possible to do it on web interface:


EMCLI verb “get_jobs” reports all runs of the jobs, and “delete job” can delete job and its (more...)

Oracle Data Integrator 12c: Getting Started – Components and Architecture

I’ve decided that it’s time for a refresher on Oracle Data Integrator 12c. I’m writing a Getting Started series to help folks get interested in the product and maybe even teach a few old dogs (including myself) some new tricks. In my last post, I shared the history of ODI and a bit about what sets it apart from other ETL tools on the market. In this article, I’ll walk through different components of (more...)

JDeveloper Bug and Workaround – Wrong Instance Name for Method Action Binding

After upgrade to JDeveloper I have noticed issue related to Method Action binding instance name. This is not ADF bug, but JDeveloper bug. JDeveloper sets incorrect name for Method Action binding instance name.

If you are going to create custom method in VO/AM and expose it through interface to be called in bindings layer - there will be similar error as below on runtime:

Source of this (more...)

The Vicious Index that Sabotages Plans it is not Part of [@DBoriented]

We all know that adding a new index may change the execution plans of existing queries – sometimes improving the performance, other times causing a performance degradation (and sometimes not making any difference).
But is it true even if the new index is not used by the new execution plan? And even if the new index is invisible?
I’ve recently discovered that the answer is yes for a specific scenario that involves a descending and (more...)

OTN APAC Tour 2016 : It’s Nearly Here!

ace-directorIn a little over a week I’ll be starting the OTN Asia Pacific (APAC) Tour 2016, or to be more accurate I’ll be starting the first half of it.

I’ll be attending the following events.

  • Wellington, New Zealand: October 26th (Event)
  • Auckland, New Zealand: October 27th (Event)
  • Sydney, Australia: October 31st (Event)
  • Gold Coast, Australia: November 2nd (Event)

The tour carries on without me (I had (more...)

Thinking about using Python scripts like SQL scripts

I’ve used Python to make graphs of Oracle database performance information. I put the scripts out on GitHub at https://github.com/bobbydurrett/PythonDBAGraphs. As a result I’m keeping my Python skills a little fresher and learning about git for version control and GitHub as a forum for sharing Open Source. Really, these Python scripts were an experiment. I don’t claim that I have done any great programming or that I will.

But, as I review what I have done (more...)

Dallas Oracle User Group Performance & 12.2 New Features Technical Day

Just letting people in DFW area know that I’m speaking at the DOUG Performance & Tuning and 12.2 New Features Technical Day!


  • Thursday 20 October 2016 9:30am-5:30pm


  • Courtyard & TownePlace Suites DFW Airport North/Grapevine, TX
    2200 Bass Pro Court|Grapevine, TX 76051

Speakers (Seven Oracle ACE Directors!):

  • Jim Czuprynski

  • Charles Kim

  • Cary Millsap

  • Dan Morgan

  • Kerry Osborne

  • Tanel Poder

  • Nitin Vengurlekar


  • I’ll speak about In-Memory Processing for Databases where I plan (more...)

Pint with Oracle User Group – First International POUG (Polish) Conference

Kamil kicks it all off: Apparently water has bacteria in it - so drink beer! (stolen from Pieter v.Puymbrooeck)

Kamil kicks it all off: Apparently water has bacteria in it – so drink beer
(stolen from Pieter v.Puymbrooeck)

Last week I enjoyed being at the first international conference that the resurrected Polish Oracle user group has put on. I say enjoyed – I actually mean really enjoyed! Why did I like the conference so much? Three major components came together.

(Before anyone rushes to mention the Polish custom of entertaining you with alcohol, (more...)

Oracle is proactive

Oracle being proactive about out-of-support systems, patch availability and expiring passwords is nothing new. But this takes it to a different level altogether.


In database row archiving in Oracle 12c


In the article you will have a look at the new Oracle 12c feature called in database row archiving available since Oracle 12c. In Oracle versions prior to 12c all table data was an active visible set of data, that is subject to DML performed by the application. In Oracle 12c the In database row archiving feature enable us to have two sets of table data an active visible set of data that coexists (more...)

Smoke and mirrors: monitoring function calls that do not exist anymore

During investigating I ran once again into statistics in the Oracle database that still provide a useful details, but the actual naming of the statistic is describing a situation that in reality does not exist anymore. The statistics I am talking about are ‘calls to kcmgcs’, ‘calls to kcmgrs’, ‘calls to kcmgas’ and ‘calls to get snapshot scn: kcmgss’.

Disclaimer: this is research. Any of these techniques potentially can crash your instance or leave your (more...)

Trace Files Split in Multiple Parts

Last January, in the following tweet, I pointed out that the documentation vaguely mentions that a trace file may be split into several files.

As a follow-up, few days later Jonathan Lewis published a post entitled Trace file size.

Until recently, I didn’t bother to investigate how that feature works. But, (more...)

October Webinar Series: Digital Transformation, Forms and Mobile

This year’s Oracle Open World was an exciting experience for AuraPlayer, with many flocking to our booth for live demos and attending Mia’s sessions with clients like Rogers Group Inc. We were sad that many were unable to attend the conference, so we are bringing Oracle Open World to you in our October webinar series!

In the first installment of this series, “Digital Transformation: From Legacy to Enterprise Mobility,” we will demonstrate step-by-step how best (more...)

OTN Nordic ACE Tour : A Tale of Three Cities

3 days - 3 cities - 6 presentations (4 different ones)

My tour started on Monday afternoon when I left my house around 1.30PM to get on the bus to the train station. The 2PM train left exactly on time for the Amsterdam airport. I arrived at Schiphol around 3:30PM, perfectly on time to catch the 5PM flight to Copenhagen.
The flight to Copenhagen was very uneventful. From the airport I took the train (more...)