Database roles – 2. Big…Mistakes?

Looks like my Friday post about BigData got some attention. In that case - let's continue! While looking at tons of articles about Big-anything I've noticed a very constant pattern - everybody is talking about multi-node clusters of database servers: you constantly hear about horizontal scalability, sharding, node failure tolerance (more...)

Offline Oracle Service Bus Configuration export

With Oracle Service Bus PS6 or we finally have an new offline build tool with does not require Eclipse (OEPE).  With this OSB configjar tool ( located in the OSB home /tools/configjar/ folder ) you can make OSB export sbconfig jar based on 1 or more (more...)

JRockit Real Time

Since JRockit is dead this post might not be interesting, but anyway …

I have never used JRockit Real Time (JRRT). At a customer site I could see that JRRT was installed and the custom said that they used it.

But there was also installed a newer regular JRockit and (more...)

Protect the Apache HTTP Server against CRIME SSL/TLS attacks

It is now possible to protect Apache on both Windows and Red Hat servers against CRIME SSL/TLS attacks.

I have updated my Hardening the Apache HTTP Server post accordingly.

APEX 4.2.2 released

Oracle Application Express (APEX) 4.2.2 is now released, you can read up and download it here, or try it out on In addition to fixing some bugs Oracle APEX 4.2.2 includes a major upgrade of all 18 productivity and all 16 database (more...)

APEX-Community meets Development – Munich, May 16th

Mark your calendars for May 16th. Following the Cloud World events (more...)


Over the weekend one of my friends asked me for a clarification on RESULT_CACHE - a really interesting functionality that allows Oracle to cache in SGA results of PL/SQL function calls.

The point of confusion was the fact that between 11gR1 and 11gR2 Oracle development team significantly re-thought this feature (more...)

Oracle made a few changes in Oracle 11g OCM Exam Environment and Exam Topics

Exam Environment

Current Environment
(Till 12th May 2013)
New Release Environment
(From 13th May 2013 onwards)
Oracle Linux Release 5.4 (64-bit)
Oracle Linux Release 5.4 (32-bit)
Oracle Database Enterprise Edition Release (64-bit)
Oracle Database 11g Enterprise Edition Release 11.2.0. (more...)

How to Move USER_SDO_GEOM_METADATA like a Grandpa

Sometimes moving a small amount of data in Oracle database requires more work than the actual task you need to complete. DBAs always have their tools (PL/SQL Developer Text Importer is my favorite one) to move a small amount of data between databases.
But when it comes to nested tables (more...)

Oracle Application Express 4.2.2 Patch released

Just yesterday, the most recent APEX patch set has been released. It is Release The full version just as well as the patch set to apply to a 4.2.0 or 4.2.1 instance can be downloaded from here.

The full details can (more...)

Oracle OTN Developer Day in New York on May 7th

Are you interested in developing and running your Oracle Application Express applications (more...)

PDF Printing with Oracle Application Express 4.2.2

Oracle Application Express 4.2.2 was released today, you can download the full release from the Download page on OTN. As always, there have been numerous improvements and bug fixes. We’ve updated many of our included packaged applications and we’ve introduced a new packaged application: the Survey Builder, which (more...)

OAM and EBS Breaks after Cloning

| Apr 26, 2013
We are in the process of integrating E-Business Suite with Oracle Access Manager (OAM). Its setup in DEV and TEST but not in PROD yet.    There was a requirement to reclone DEV and as a result the integration with OAM broke. We ran all the configuration steps on the (more...)

Database roles: BigData, BigUsers, Big…Problems?

Today at lunch we had an interesting discussion about the role of databases in the contemporary IT development - and there was a lot of buzz-words thrown across the table: Hadoop, NoSQL, BigData, BigUsers, ACID-compliance etc. To be fair, a bit too many buzz-words - I have a very bad (more...)

Performance tuning. Spending time is NOT OK (if you do not know exactly why)

Yet another performance tuning story, similar to one that happened about a month ago. Just to keep it short:

  • once upon a time there was a very time-consuming module.
  • eventually we were forced to take much closer look - WHY is it so time-consuming
  • we found in our own (more...)

Collaborate’13 Summary. Part 4. Database development

This post is the final part of my thoughts about IOUG Collaborate'13 conference (part onepart twopart three). If I will not write I now I will forget what was going on :-), so the last push!

4. Real stuff

In all of the previous (more...)

Oracle Internals. Digging out PL/SQL fine-grain dependencies

After a couple of requests at IOUG Collab'13 I decided to resurrect a pretty old topic that I've participated in 2008 (since in 5 years there was no changes on that front :-) ).

As we all know, starting version 11g Oracle tracks PL/SQL dependencies in much more granular way (more...)

Using the Apache HTTP Server as a forward proxy to the Internet

Often you do not want servers in your internal network segments to be able to access the Internet directly.
One way to get controlled access to the Internet is to place an Apache HTTP Server in a DMZ network segment. Internal servers can then use the Apache server as a (more...)

Using the Apache HTTP Server (mod_proxy) as a reverse proxy to a WebLogic Server

If you are using a WebLogic Cluster you need a proxy in front of the cluster to provide load balancing. You need either a hardware load balancer or a Web Server with the Oracle Web server plug-in.

Even if you are not using a Cluster it makes sense to place (more...)

Join me at ODTUG’s Expert Panel – Oracle Application Express

In May, I will take part in one of ODTUG's webinars:

Tuesday, May 14, 2013 12:00 PM - 1:00 PM EDT

ODTUG's Expert Panel - Oracle Application Express

Panelists: Dietmar Aust (Opal Consulting), Roel Hartman (APEX Evangelists ), Dan McGhan (Enkitec)
Moderator: Patrick Cimolini (Patrick International APEX Consulting)