How to rename ASM disk groups in Exadata

Deployment of Exadata requires you to generate configuration using Oracle Exadata Deployment Assistant (OEDA). Within the same the default  ASM disk groups names are DBFS_DG, RECOC1 and DATAC1. I usually change those to RECO01 and DATA01 as others doesn’t make sense to me and the only place where I find the default ones is on Exadata.

I had an incident last year where the Exadata deployed half way through and names were left by default (more...)

WebCenter Portal Certified with E-Business Suite 12.2

Oracle WebCenter Suite is an integrated suite of Fusion Middleware 11gR1 tools used to create web sites and portals using service-oriented architecture (SOA).  Applications adapters are also available.

WebCenter Development Framework

WebCenter Portal is now certified with Oracle E-Business Suite Release 12.2.  WebCenter Portal is part of Oracle Fusion Middleware 11g Release 1 Version, also known as FMW 11gR1 Patchset 8. 


Oracle Midlands : Event #12 – Summary

Tonight was Oracle Midlands Event #12 with Bryn Llewellyn  and Neil Chandler.

Bryn very kindly stepped in for Tom Freyer who unfortunately couldn’t make it. Bryn’s presentation was called Why use PL/SQL?, which was based on his whitepaper of the same name. I’ve written about a number of the topics he raised, including a piece on My Utopian Development Environment, but his talk and his whitepaper put forward a much more consistent and compelling argument. Definitely worth checking (more...)

Why ALL Tools in at Your Disposal ARE IMPORTANT

After my AWR Warehouse session at DOAG in Nuremberg, Germany last week, an attendee asked me if he really needed to use trace files anymore with the value provided by AWR, (Automatic Workload Repository) and ASH, (Active Session History.)  I responded that trace files were incredibly valuable and should never be discounted.

To use an analogy, when I was 22 years old, and entered a doctor’s office missing a small percentage of my visual (more...)

Advanced Compression Option Caveat in Oracle 12c


Oracle 12c introduced a new capability to move a partition online, without any interruptions to DML happening at the same time. But, there’s a catch. So far we’ve been able to use basic table compression without having to worry about any extra licensing – it was just a plain EE feature.

If you are planning to use the online partition move functionality, carefully check if you’re not using basic compression anywhere. For example:

create (more...)

Promoting Unmanaged Targets Automatically

Recently a customer asked if it was possible to promote unmanaged targets automatically without any interaction. They were already using auto-discovery.

The answer is yes, and of course as soon as you see words like “without any interaction” you know there’s going to be scripting involved. In the Enterprise Manager world, scripting is handled by the EM Command Line Interface, better known as EMCLI. I’ve posted some example scripts of using EMCLI a while back (more...)

AIOUG Sangam15 : It’s a Wrap!

The whole Sangam15 experience is over for me now!

Here are the posts I put out during the trip.

I did my thank you messages in the Day 2 post, but once again I would like to say a big thank you to AIOUG for inviting me, to the Oracle ACE Program for getting (more...)

AIOUG Sangam15 : The Journey Home

The night before a morning flight is always a little tricky for me. I lie in bed thinking, “What if I oversleep?”, which winds me up and makes it really hard to relax and drop off. I dozed on and off, but eventually gave up, turned the TV on and watched some films for a few hours.

I grabbed a quick breakfast and got the taxi to the airport. The hotel staff advised leaving (more...)

Table Expansion

I’ve often found that while I’m investigating one Oracle feature I get waylaid by noticing anomalies in other parts of the code. I was caught by one of these events a little while ago while experimenting with the new ( Inmemory Columnar Store.  After reading a posting by Martin Bach I asked the question:

“If you have a partitioned table with a local index and one of the table partitions has (more...)

My Presentations at DOAG & BGOUG: EMCLI Crash Course

Last week, I gave presentations at DOAG (German Oracle User Group) conference and BGOUG (Bulgarian Oracle User Group) autumn conference about Oracle Enterprise Manager Command Line Interface. It was my first time at these conferences, and both of them were wonderful.

Before each session at DOAG Conference, there was a video showing “how they prepared the last year’s DOAG conference”. What a professionalism! What a great team work! You know Germany is known for their (more...)

My New Youtube Channel

I have created a new youtube channel – and have uploaded some videos there already! Bookmark & Subscribe here:

More stuff is coming over the next weeks & months :-)


NB! After a 1.5 year break, this year’s only Advanced Oracle Troubleshooting training class (updated with Oracle 12c content) takes place on 16-20 November & 14-18 December 2015, so sign up now if you plan to attend this year!

Migrate an application to the APEX 5.0 Universal Theme

iAdvise presented the APEX 5.0 roadshows in the first half of 2015. Besides the presentation about the new features, we provided 3 tutorials which helped the visitors to explore Oracle Application Express 5.0. Now we offer these tutorials through our blog. In this article the second tutorial is presented.

This tutorial helps you step by step through the process of migrating an application to the Universal Theme of Oracle Application Express 5.0. In this tutorial we talk about (more...)

Restrictions on the append hint

I wanted to add an append hint to some code but realised that there are known restrictions when either triggers or referential integrity are involved.

That does make sense as potentially rows would be inserted that either did not fire a trigger or broke RI constraints.

I decided to produce a test case to prove that the restrictions did work and were still in place.

Test append with trigger created

set lines 240
set pages  (more...)

AIOUG Sangam15 : Day 2

My session on Day 2 started at 11:10, where I spoke about running Oracle Databases in the Cloud. This included a quick run through of the Oracle DBaaS offering and AWS RDS for Oracle amongst other things.

The session generated a lot of interest. In fact, I spent the next 5 hours answering questions and taking photos with people. It sounds kind-of crazy, but it was really good fun. As a result, I didn’t get to (more...)

AIOUG Sangam15 : Day 1

I was up at about 04:00 on Saturday and waiting for breakfast to open at 06:30. Pretty much as soon as I ate something I felt really tired again. That after a day of sleeping… :)

I headed on down to the conference and instantly saw a bunch of friendly faces, including lots of people I had met on the OTN Yathra 2014 Tour.

After the keynotes, I got to have a quick chat about User Groups (more...)

Log Buffer #450: A Carnival of the Vanities for DBAs

This Log Buffer Editions picks few blog posts from Oracle, SQL Server and MySQL.


  • If you grant the DBA role to a user, Oracle also grants it the UNLIMITED TABLESPACE system privilege. If you then revoke the DBA role from this user, Oracle also revokes its UNLIMITED TABLESPACE system privilege.
  • Lost SYSMAN password OEM CC 12gR5.
  • How Terminal Emulation Assists Easy Data Management.
  • Using EMCLI List Verb to Get Detailed Information of EM Targets.
  • (more...)

Tech Tip: Connect to Snowflake db using #SQLDevModeler

So, some of you may have noticed that I took “real” job this week. I am now the Senior Technical Evangelist for a cool startup company called Snowflake Computing. Basically we provide a data warehouse database as a service in the cloud. Pretty cool stuff. (If you want to know more, check out our site […]

IBM Bluemix Secure Gateway Service with Oracle

I previously blogged about using the IBM Bluemix Secure Gateway Service as follows

I decided I would extend on this and Connect a Spring Boot Application to Oracle and consume Oracle data using the Secure Gateway Service.

The full demo is as follows

AIOUG Sangam15 : The Journey Begins

The day started pretty early. I was packing at 00:00 and the alarm went off at 05:00. Nothing like last minute packing to focus the mind. :)

The taxi to the airport was good. The driver was interesting, speaking to me about his visits to India and Pakistan. It certainly helps pass the time when the driver is chatty.

I wasn’t able to check-in online, but there was no queue at the check-in desk, so that was quick. (more...)

Extent Allocation

Some references on extents dealing with extent trimming, initial extent for parallel load, tablespace fragmentation, etc…


Parallel Load: Uniform or AutoAllocate extents?

Tom Kyte covers this problem in great details in his post Loading and Extents

Initial Extent Size of a Partition Changed to 8MB from 64KB After Upgrade to or Later (Doc ID (more...)