Hybrid Cloud Management

Here is Youtube video for more insights on Hybrid Cloud Management   :)

IBM Bluemix – Triggerring backing service creation from "Deploy to Bluemix" button

I recently posted about the "Deploy to Bluemix" button which will automatically deploy an application into IBM Bluemix from a single click.


If the application requires backing services they can automatically be created using the"declared-services" tag as shown below. Declared services are a manifest extension, which creates or looks for the required or optional services that are expected to be set up before the app is deployed, such (more...)

Once A Week Is Never Enough

Over the last few months we have been looking at User Engagement and recently asked people take part in a global usage survey so we could create a series of benchmark metrics detailing how organisations used OBIEE.

We had a great response and have started to process the data. One of the first things that struck us was that the average user logs into their OBIEE system about once per week.



We derive the (more...)

Preventing cloud control alerts for controlled restarts

We have hooked cloud control into the request tracker ticketing system (and by hooked in i mean that cloud control just sends an email notification which is then picked up by request tracker to generate a ticket - nice and simple).

This means we get tickets generated for every alert we configure in cloud control (it's also the same system that users can request service requests in - again they just send an email in (more...)

Analytische Funktionen (Teil 2): LISTAGG mit eindeutiger Liste

Die LISTAGG Funktion dient der Generierung von zusammenkonkatenierten Strings auf Basis einer Spalte. Wenn in der Spalte ein Wert mehrfach vorkommt, dann wird die Liste ebenfalls mit doppelten Werten generiert.

Im folgenden demonstriere ich ein Beispiel um dieses Problem zu lösen.

Beispieldaten - Land und Ort:

JavaScript on the App Server: Scripting PeopleCode

It has been nearly a decade since I started playing with JavaScript on the PeopleSoft application server. Back then I had to deploy a couple of JAR files to the app server. At that time, maintaining and deploying unmanaged files seemed more headache than benefit. Today Java provides full scripting support through the ScriptEngineManager and embedded Mozilla Rhino JavaScript script engine. Why would I want to script PeopleCode? Here are a few of my favorite (more...)


Often, the biggest problem with regular expressions is that those who use them sometimes don’t use them correctly. A great example occurs in the Oracle Database with the REGEXP_LIKE function. For example, some developer use the following to validate whether a string is a number but it only validates whether the first character is a number.

  lv_input  VARCHAR2(100 (more...)

ON COMMIT Materialized View Causes ORA-02050 and ORA-02051

This example replicates a problem I discovered today. I tested it in an Oracle 11.2 database. First I created an empty table called tab1:

SQL> create table tab1
  2  (col1 varchar2(30),
  3   constraint con1 primary key (col1))
  4  /
Table created.

Then I set up a materialized view on the table. Note that it is refreshed on commit:

SQL> create materialized view log on tab1

OpenWorld 2015 Conference Schedule

Just a couple more weeks and we will be enjoying the great weather and hospitality of San Francisco. I am anxiously anticipating another great OpenWorld conference. As always, I look forward to meeting with you between sessions or in the demo grounds. I will be presenting "PeopleSoft Developer: Tips and Techniques [CON8596]" on Monday, Oct 26 at 12:15 p.m. in Moscone West—3007.

I find the OpenWorld/JavaOne content catalog a little intimidating. If you are (more...)

DOAG Conference Presentation Summary Finished

Hi guys,

today was the deadline for uploading the four-page abstract / summary of my presentation at the German Oracle conference in Nürnberg:

If you still have to upload yours, hurry up ... only a few hours left ;).

You can have a look here (it is German though ;). 

See you in Nürnberg in November.


Oracle Mobile Cloud Service – External SOAP Service Connector

These days everything is about MCS/MAF. I'm also looking into this new area, but I'm trying to mix traditional ADF topics and new things. Who knows may be MCS/MAF is a new big thing and its good time to learn it. I was testing how it works to define my own custom SOAP connector to calculate currency conversion rate.

MCS developer portal allows to create and use new connector. Special wizard helps to complete this (more...)

DAM tools, IBM Guardium, Oracle E-Business Suite, PeopleSoft and SAP

A question we have answered a few times in the last few months is whether or not, and if so, how easy do Database Activity Monitoring (DAM) tools such as IBM Guardium support ERP platforms such as the Oracle E-Business Suite, PeopleSoft and SAP. The answer is yes; DAM tools can support ERP systems. For example, IBM Guardium has out-of-the-box policies for both the E-Business Suite and SAP – see figures one and two below.


Automation for DBA – Ansible part 1


In this post I would like to move forward with software provisioning and configuration. In my last post I covered a ways to build a "core VM" and now it's a time to add some software and configuration to it.

There is a couple of automation tools which can be used for that task like Puppet, Chef or Ansible to name a few. The latter one - Ansible - is my favorite, cause in (more...)


Here’s a live on from OTN – here are a couple of extracts from the problem statement:

We’re experiencing an issue where it seems that the query plan changes from day to day for a particular procedure that runs once a night.
It’s resulting in a performance variance of 10 second completion time vs 20 minutes (nothing in between).
It started occurring about 2 months ago and now it’s becoming more prevalent where the bad (more...)

PeopleTools Mobile Book Now Shipping

I received notice yesterday that our latest book, PeopleSoft PeopleTools: Mobile Applications Development (Oracle Press) 1st Edition, is now shipping. Probably the most exciting news is that Amazon has the book listed as the #1 New Release in the Oracle Databases category.

Global startup map

Global startup map

Following the several indexes on startups and innovation I’ve been following last period I found an interesting map of startups. Startupblink offers a world map of the startup ecosystem. You can use the startup map to zoom, filter etc the startups in your neighborhood. Besides a map of startups, it offers information on other related entities such as co-working spaces, accelerators, startups organizations, tech reporters and much more…

You can read an (more...)

[Video] Getting Started with Formspider

Yesterday we hosted a webinar for people who are interested in learning Formspider but could not find the time. Don’t worry if you missed it though! Below is a recording of the event.

The webinar consists of seven parts:

1) About Gerger, the company behind Formspider.

2) Brief history of Formspider and a short overview of its references and success stories.

3) Formspider Benefits & Features.

4) Formspider Architecture

5) Overview of the Formspider IDE


SQL Profile and Plan Baseline Notes

Optimizer with Oracle Database 12c
Oracle White Paper – June 2013

What is the difference between SQL Profiles and SQL Plan Baselines?
By Maria Colgan-Oracle on May 08, 2012

Plan Stability using Sql Profiles and SQL Plan Management
Amit Bansal / 20 December, 2011

3 OCT/10

Comments from Kerry Osborne September 9th, 2011 – 18:31
You didn’t mention the two biggest differences (in (more...)

Performance testing at bol.com

Performance testing at bol.com

On Monday October 12th Rob de Groot and Chris Kramer of the bol.com test automation team and development process innovation team will present on performance testing at bol.com. The presentation is for the Dutch Web Performance & Operations Meetup, as a pre-event for the WebPerfDays.

Rob and Chris will elaborate on how performance testing evolved at bol.com and show how modern tooling like Docker and Mayfly (more...)

What To Do at OOW15 (Social & Serious)?

I’m going to OOW15 this year, my first Oracle Open World in 11 years I think. And despite the Prom Queen rejecting all my offerings, I will actually be sneaking in a presentation – which I am very happy about.

The European Oracle User Group (EOUG) get a few slots and two are being used on Sunday 25th, 13:30 – 15:15 for “More Than Another 12 on Oracle Database 12c” – 12 European experts (more...)