LEAP#331 Getting Blinky with PIC Assembler

Not necessarily everyone’s first choice for embedded development these days, PIC is perhaps now more a right-of-passage! It was Julian Ilett who finally inspired me to try this myself. One thing that held me back was the perception that you have to “downgrade” to Windows in order to get anything going. Challenge accepted, and I quickly learned that the MPLAB X IDE is just perfect and makes PIC development on MacOSX a piece of cake. (more...)

What Employers Want : Stop Making the Same Mistakes

This isn’t so much what employers want, as some observations about mistakes I see people make all the time. Think of it as ways to avoid wasting time and making yourself look stupid!

  • Do your research. Know what you are applying for and who you are applying too.
  • Apply to a company in the appropriate way, typically described on their website. If you don’t use their preferred channels, you’ve probably wasted your time.
  • As an (more...)

Oracle Tidbits – July 2017 #oratidbit

“Oracle *daily* TidBits” (#oratidbit) published on Facebook, Twitter, and Google+ during weekdays in July 2017. You will also see these tidbits, one tidbit at a time, for each page refresh on the right side of this blog as well… Hope you find these helpful to learn something new or to remind you of its existence and use. […]

Result cache latch contention

I recently saw a dramatic example of result cache latch contention. I had just upgraded a database to and several hours later processing pretty much came to a halt.

Of course I am telling you the end before I tell you the beginning. It all started the morning of July 22nd, 2017, a few weeks back. We had worked for a couple of months on an upgrade. (more...)

LIVE TODAY! (August 8th) Six Hour Event on New Features of Oracle 12cR2

Six hour live stream of two ACE Directors, Rich Niemiec and Nitin Vengurlekar talking about their favorite new features of Oracle 12c Release 2. We are at 332 signups already. Register at this link.

More Oracle Security Training Manuals for Sale

I advertised here some months ago a small number of printed manuals that I found in our company storage for some of my Oracle security classes. We had these printed over the years for various classes that I taught and....[Read More]

Posted by Pete On 08/08/17 At 01:57 PM

HP Systems Management vacancy

I know I do not have the right readership on this blog for a Systems Management vacancy but if any readers have colleagues who have experience using any of HP Openview, OpsBridge, HP Service Management and HP UCMDB then I have a vacancy at our Head Office in Bradford for a permanent position

Details below


Getting started with MapR-DB Table Replication

Read & comment this article on my new blog Introduction MapR-DB Table Replication allows data to be replicated to another table that could be on on the same cluster or in another cluster. This is different from the automatic and intra-cluster replication that copies the data into different physical nodes for high availability and prevent data loss. This tutorial focuses on the

What Employers Want : Make Yourself Stand Out

If a job is worth applying for, lots of other people will be applying for it as well. What makes you stand out?

If you’ve taken on board some of the previous posts you already know about qualifications, enthusiasm, self-sufficiency, communication skills, confidence etc. If you’ve got those things down, you are on the right path, but what else can you do? Here are some of my opinions…

Blog : Over the course of your career (more...)

Switching to a Physical Standby

[contact-form]Now that I’m back to doing more normal DBA work (see here for the reasons behind that), I’ll be posting some more how-to type posts from a DBA perspective, not necessarily an EM perspective. While I’m hoping these posts will be of interest to others, I also want to use them to keep track of just how I did different things so I can rinse and repeat as necessary. 😊

This first post will be covering (more...)

Two configuration changes with upgrade

A couple of weeks ago I upgraded a major production database from to Our developers kept hitting one ugly bug after another on the minimally patched so I wanted to get them on the most patched up version of Oracle 11. This is on HP-UX Itanium 11.31. I made two key configuration changes that I want to discuss here. I changed the (more...)

Last Week in Stream Processing & Analytics – 7.8.2017

This is the 76th 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


List of the tools I use and why I use them

This post is part of a series of posts: From idea to app or how I do an Oracle APEX project anno 2017

I initially thought to only list the software tools I use, but tools are more than software alone. As a developer I find it important you have everything you need to be successful. For me that means a clean desk, a whiteboard, paper and some writing material (as explained in my previous (more...)

Heading ‘into the wild’ for guerilla research on emerging tech

The OAUX Emerging Technologies team, or The AppsLab, researches technical innovations coming down the pipeline. Part of our goal is to assess the potential of the technology – is it easy to adopt? Are there use cases that might make work easier for enterprise employees to complete their tasks?

Our research on emerging technologies finds three ways to enhance the user experience: Automate tasks to increase efficiency, advise customers on the best practices based (more...)

New Oracle Security On-Line Training Dates Added

We have finally added new on-line training dates for some of our classes; the very popular two days "How to perform a security audit of an Oracle Database" is first followed by the one day class "Hardening and Securing Oracle....[Read More]

Posted by Pete On 07/08/17 At 06:30 PM

Auto enabling APPROX_* function in the Oracle Database

With the releases of 12.1 and 12.2 of Oracle Database we have seen some new functions that perform approximate calculations. These include:


These functions can be used when approximate answers can be used instead of the exact answer. Yes can have many scenarios for these and particularly as we move into the big data world, the ability to process our data quickly is slightly more important (more...)

Words I Don’t Use, Part 4: “Expert”

The fourth “word I do not use” is expert.

When I was a young boy, my dad would sometimes drive me to school. It was 17 miles of country roads and two-lane highways, so it gave us time to talk.

At least once a year, and always on the first day of school, he would tell me, “Son, there are two answers to every test question. There’s the correct answer, and there’s the answer that the (more...)

Upgrading an Amazon EC2 Delphix Target, Part IV

It’s finally time to upgrade our Linux Target!  OK, so we’re not going to upgrade the way a DBA would normally upgrade a database server when we’re working with virtualization.

So far, we’ve completed:

  • 1.  Updating our instances so that we’ll have a GUI interface if we’ll need one.
  • 2.  Installed Oracle on the Linux Source and upgraded our Dsource database to 12c


Now we’re done with (more...)

SQLDeveloper 4.2 problem with some bind variables values

| Aug 7, 2017
I just found out that SQLDeveloper version (tested on windows 10) might execute SQL or PL/SQL code containing bind variables with wrong argument values when such values are strings (VARCHAR2) containing just digits with leading zeros (i.e. international phone numbers, VAT codes, UPC codes...) entered at the bind variables prompt.This seems to happen only with PL/SQL code or certain

Real-Time Materialized Views mit 12.2

Bereits vor einigen Wochen hat Richard Foote einen Artikel zu den Real-Time Materialized Views veröffentlicht, die mit 12.2 eingeführt wurden. Grundsätzlich ist deren Verfahrensweise offenbar relativ einfach: beim Zugriff auf einen nicht vollständig aktuelle MView werden die Informationen der Materialized View mit denen des Materialized View Log kombiniert: es erfolgt also kein ad-hoc-Refresh des MView-Segments, sondern eine Verknüpfung der Daten des MView-Segments mit den Deltas, die im MView Log gespeichert werden. In der MView-Definition (more...)