A quick look at Oracle Process Cloud Service

Oracle Process Cloud Service is Oracle’s rapid process automation in the Cloud. It is more or less BPM in the cloud. This service allows you to quickly and easily create business processes like you are used to with Oracle BPM, only now in the cloud. In this post I’ll give a quick tour of this service.

So let’s start with the Process Cloud Service. The landing page already gives you loads of features.

The landing page of the Process Cloud The landing (more...)

Writing Tips : Can I get paid to write?

writingI’ll prefix this post with a warning. I’ve never done any paid blogging myself, so this is based on emails I’ve received from people requesting me to write for them and from comments I’ve heard from others. With that in mind…

Apart from having adverts on your blog or selling books, there are other ways to earn money from writing. You will have to decide if they suit you.

Paid Articles. Some websites, blogs and magazines pay for (more...)

Nymi Band Impressions

Editor’s note: Here’s the first post from Osvaldo Villagrana (@vaini11a), one of our AppsLab Mexico team members. Enjoy.

During last week I’ve been playing with Nymi Discovery Kit I got back in our AT&T hackathon participation, and here are my impressions as a developer for Nymi SDK point of view and as a user.

For those who don’t know, this band is wearable biometric identity device that let’s you use your heart’s (more...)

Stop That!

"It seems to me that almost everything is a waste of time."
- Norton Juster, The Phantom Tollbooth 

Jonathan Lewis has coined a term and its definition that, I believe, we’ll be using quite a bit:

Stoptimisation - the art of optimisation by not doing the things you don't need to do.

It’s a term we’ve needed for some time now, given the pendulum swing back to the days of yore (meaning pre-9i) with (more...)

Making Existing SQLPLUS Scripts 12c and Container DB (PDB) Compatible

Oracle 12c introduces new catalog features including CDB_ dictionary views (which include a CON_ID column) superseding the DBA_ views that most DBA sqlplus scripts are based upon.

However, existing DBA sqlplus scripts can easily be modified using just a few simple sqlplus techniques to be compatible with 11g, as well as all types of 12c databases including legacy and container databases.

The following simple SQL and sqlplus techniques can be used to make a “universal (more...)

SQL Performance, Part IV. Heap tables.

Demo script

OBIEE New Features for Front-End Developers and Business Users

OBIEE was released this May and Robin and Mark wrote great posts about New Features from System Administrators and the new support for HiveServer2 and Cloudera Impala respectively. In this post, we will see some useful new features for Front-End development. Some of these features like tree map, new styles, etc. were included in the OBIEE version, but I’m including them here anyway because if you (more...)

Franck Pachot über SQL Plan Directives

In den letzten Wochen hat Franck Pachot eine Reihe interessanter Artikel zum Verhalten von SQL Plan Directives veröffentlicht, die ich an dieser Stelle grob vereinfachend zusammenfasse. Eine Einleitung zum Thema wollte ich mir eigentlich sparen, da ich etwas Derartiges hier bereits untergebracht hatte, aber der Herr Pachot hat es in Matching SQL Plan Directives and extended stats so schön zusammengefasst, dass ich mir seine Erklärung ausborge:
SQL Plan Directives in USABLE/MISSING_STATS state can create column (more...)

OTN EMEA – Jordan

Stop two was Amman in Jordan, and a lesson in preconceptions and assumptions.

First we had to get there and it was two flights, one to Istanbul and then onto Jordan, both on Turkish Airways. We should have had just 2 hours in Istanbul but the 2nd flight was delayed which gave us another few hours to enjoy what must be on of the world's nicest lounges. 

It wasn't my best journey, I was (more...)

OTN EMEA – First Stop Portugal

My part in OTNEMEA was all too quickly apon us. I arrived in Lisbon at about 6pm, having worked on the 2 hour flight, and still had a conference call to take part in. Luckily Heli Helskyaho was expected at 7.30 so I was happy to find a quiet corner and get on with it.

Luis and Nuno from the Portuguese Oracle User Group came by to collect us and although Heli's flight was (more...)

CHEP 2015 papers on replication and scale-out databases

CHEP 2015, the 21st international conference on computing in high energy physics, has taken place in April 2015 in Okinawa, Japan. Here below you can find the links to the pdf of the talks, posters and related preprints of two of the contributions by members the CERN database group. These are on the topics of our tests with scale-out databases (in particular on the Hadoop platform) and on the evolution of the replication technologies (more...)

Writing Tips : How can I make money?

writingYou’ve started a blog. This time next year you’re going to be a millionaire!

If you are interested in making money from a website you can. There are a number of advertising options, with the most popular for the small publishers being Google Adsense. Having said that, you’re going to get a rude awakening when you start earning 20 cents a day.

Advertisers care about reach, so advertising is a numbers game. If you want (more...)

Oracle #DB12c New – MAX_STRING_SIZE

In pre-12c database releases, VARCHAR2, NVARCHAR2 data types were limited to 4000 bytes and RAW data type was limited to 2000 bytes. If there is a need to store more data in VARCHAR2 column, you can in 12c after setting the parameter MAX_STRING_SIZE to EXTENDED. With setting MAX_STRING_SIZE to EXTENDED, you can store up to […]

Smart Scan enhancements in Oracle Exadata 12c-inline LOBs

As part of the 12c release of the database and cellos Oracle introduced the ability to perform Smart Scans on inline LOBs. The enhancement is certainly for Secure Files only. And as always, if you would like to read up about Secure Files you can head over to Tim Hall’s website for the details.

To demonstrate the new behaviour I have used an BP 22 database on Exadata 11.2.3. (more...)

Temp Table Transformation Cardinality Estimates – 1

Having published recently two notes about the Temp Table Transformation highlighting the heuristics based decision and other weaknesses, for example regarding the projection of columns, it's time to publish some more notes about it.The transformation can also have significant impact on cardinality estimates, both join and single table cardinality.Looking at the difference in the join cardinality estimates of following simple example:

create table t1
rownum as id
, mod(rownum, 10) (more...)

Writing Tips : A URL is for life, not just for Christmas!

writingI’m currently doing yet another pass through my whole website correcting broken external links. This is nothing to do with my bad management. This is to do with people changing their URLs and not putting the correct redirects in place. I’ve just done a scan of my website and there are over 800 broken links to Oracle documentation!

There seem to be several ways people deal with URL changes on their website.

IoT Hackathon Field Report: Mexico Edition

I recently ventured down to Mexico to participate in an Internet of Things (IoT) hackathon organized by Laurie Pattison’s (@lsptahoe) Apps UX Innovation Events team with some of my fellow AppsLab members, Luis Galeana, Tony Orciuoli, and Osvaldo Villagrana.


Being the lone non-developer, I wasn’t sure how much I would be able to contribute—but I had done some research pertaining to our use case, so I felt I had at least that much to (more...)

“Smart quotes” showing as “?” in emails

When some of my users were using my system to send emails, they’d often copy-and-paste their messages from their favourite word processor, but when my system sent the emails they’d have question marks dotted around, e.g.

“Why doesn’t this work?”

would get changed to

?Why doesn?t? this work??

Simple fix was to detect and replace those fancy-pants quote characters with the equivalent html entities, e.g.:

function enc_chars (m in varchar2) return  (more...)

Datapump TTS quick tip

I was trying to transport a large number of tablespace datafiles from one database to another, and impdp kept crashing with “PL/SQL: numeric or value error: character string buffer too small.”

It turns out there is a limit on what you can put on a single line in a parameter file.  Hence if you have something like:


then you might run into trouble. It’s easily fixed however – just put the entries (more...)

APEX iFrame Security setting

At some point during APEX development you may find yourself putting an Oracle APEX page within an iFrame.
<iframe src="//myserver.com.au/ords/f?p=SAGE:1023:&SESSION."></iframe>

Just recently I did just that and came across an error I expected to see, but a little curious as to how it presented itself.

Refused to display '//myserver.com.au/ords/f?p=SAGE:1023:30559832045078' in a frame because it set 'X-Frame-Options' to 'DENY'.

Googling the last half of the message returns some interesting (more...)