OracleCode London 2017

My colleague & boss Ace Director Luis Weir and I where invited to present at Thursday 20th’s Oracle Code London.

oracle_codeThe request to present came late as we where needed to cover someone who had to cancel (not that we aren’t grateful for the opportunity). This did mean getting the presentation together was a little bit of a scramble, unfortunately I missed a couple of sessions as I needed to assemble an environment, work out how (more...)

Undo Understood

It’s hard to understand all the ramifications of Oracle’s undo handling, and it’s not hard to find cases where the resulting effects are very confusing. In a recent post on the OTN database forum resulted in one response insisting that the OP was obviously updating a table with frequent commits from one session while querying it from another thereby generating a large number of undo reads in the querying session.

It’s a possible cause of (more...)

Intra-block row chaining optimization in 12.2

I’ve wrote in previous post

4. Next row piece can be stored in the same block only with inserts. When you run update, oracle will place new row piece into another block.

But it’s not valid anymore 🙂 Since 12.2 Oracle optimizes updates too.
You can check it on 12.2 and previous version using example 4 from previous post:

Test 4

drop table test purge;
set serverout on
alter session set tracefile_identifier='test4';

Oracle Database on the Docker Store

You probably know that there’s an official github repository storing Dockerfiles and samples to build Docker images for Oracle products and Open Source projects. Now Oracle takes one more step to support Docker. Oracle Brings Oracle’s Flagship Databases and Developer Tools to the Docker Store (you can read the official announcement). Oracle Linux was already on the Docker Store. Oracle Database Enterprise Edition, Oracle client tools, Oracle Weblogic, Oracle (more...)

Using EMCLI for Mass Update a Property Value

Here’s a quick and simple script which can help you to update a target property value of all targets running on a specific host. The script will expect you to enter 3 parameters: host name, property name and property value. Then it will search for the targets running on the given host name, and set the property to the given value:

emcli hostname "propertyname" propertyvalue

It’s better to enter the property name in (more...)

The Chicken Before the Egg of Cloud Migrations

For over a year I’ve been researching cloud migration best practices.  Consistently there was one red flag that trips me that I’m viewing recommended migration paths.  No matter what you read, just about all of them include the following high level steps:

As we can see from above, the scope of the project is identified, requirements laid out and a project team is allocated.

The next step in the project (more...)

HCM Cloud R12 – 3 Cool Things

Just to give y'all a taste for HCM Cloud R12 as it rolls out, here are 3 new features I find really cool.

1.  Home Page with Quick Actions 

The coolness here comes from being able to easily initiate an action without requiring the user to have any knowledge of the application structure, navigation, or work area organization.  Simply find what you want to do and do it.  And, for the security geeks out there, (more...)

Be Prepared When Using DBFS

Goldegate 12c implementation for 2-node RAC with XAG from Grid Home using DBFS.

We are facing situation where DBFS has 41G free while DBFS_TS has 1.5G free and having to resize BIGFILE tablespace.

Tablespace and DBFS size is 45G.

Basically, 45G tablespace is used to maintain 4G Goldengate files.

Based on steps followed from NOTE:1453350.1 – How to Determine what storage is used in a LOBSEGMENT and should it be shrunk / reorganized?

Next step (more...)

Character selectivity

A recent OTN posting asked how the optimizer dealt with “like” predicates for character types quoting the DDL and a query that I had published some time ago in a presentation I had done with Kyle Hailey. I thought that I had already given a detailed answer somewhere on my blog (or even in the presentation) but found that I couldn’t track down the necessary working, so here’s a repeat of the question and a (more...)

Conference Networking- Tips to Doing it Right

I was in a COE, (Center of Excellence) meeting yesterday and someone asked me, “Kellyn, is your blog correct?  Are you really speaking at a Blockchain event??”  Yeah, I’m all over the technical map these days and you know what?

I love the variety of technology, the diversity of attendance and the differences in how the conferences are managed.  Now that last one might seem odd and you might (more...)

Error ORA-01033 After Doing a Switchover in a 12.1 RAC Environment

The other day I did a switchover in a RAC environment , which went pretty smooth , but after doing the switchover in the primary, I kept getting the following error:

select dest_name,status,error from gv$archive_dest_status where dest_id=2;

--------- -----------------------------------------------------------------
ERROR	  ORA-01033: ORACLE initialization or shutdown in progress

ERROR	  ORA-01033: ORACLE initialization or shutdown in progress

I went and checked the standby, and saw the standby was in recover mode (more...)

Oracle IOTs against SQL Server Clustered Indexes

I’m itching to dig more into the SQL Server 2016 optimizer enhancements, but I’m going to complete my comparison of indices between the two platforms before I get myself into further trouble with my favorite area of database technology.

<–This is sooo me.

Index Organized Tables

Index Organized Tables, (IOT) are just another variation of a primary b-tree index, but unlike a standard table with an index simply (more...)

Have a #GoldenGate question? … Go askTom


A little over two weeks ago, I attended my first Customer Advisory Board (CAB) as a product manager for the Oracle GoldenGate platform. It was very interesting being involved in the CAB from an Oracle stand point compared to a customer view point. As part of the CAB, the product management team asked customers what would be helpful in giving themselves and their organizations more insight to Oracle GoldenGate. There were many things that (more...)

What is the future for an Oracle DBA?

I have worked with Oracle databases for around 25 years now and during that time I have been very fortunate in that there has always been work for DBAs and it has been one of the higher paying disciplines within IT.

I am not prophesying the end of the Oracle database engine but I do see the writing on the wall for some of the large corporate solutions sitting on physical equipment in a datacentre. (more...)

Differentiating the ICS Agent Types – Definitive Tip #5

In our book we talked about the difference between the agents offered by ICS, namely the Connection  and Execution agents. Whilst we differentiated the two, we did focus on the connection agent as this is the type we expect to see used in most cases. However the execution agent still suffers from a level of […]

The post Differentiating the ICS Agent Types – Definitive Tip #5 appeared first on Implementing Oracle Integration Cloud Service.

Oracle Looking to Buy Accenture? Stranger Things Have Happened.

Image credit:
The Register reported that Oracle may be exploring the "feasibility of buying multi-billion dollar consultancy Accenture."

To summarize the numbers involved here, Oracle had FY16 revenues of $37 billion, net income of $8.9 billion, and a market cap of $180 billion.

On the other hand, Accenture had FY16 revenues of US$34.8 billion, net income of $4.1 billion, and a market cap of $77 (more...)

MOS plugin

Few days back I was (again) angry at My Oracle Support “The page has expired” message appearing in an open tab I left for some time. I tried to find out how to avoid it, and it was relatively easy to do even though I don’t know JavaScript. Then I tried to make a plugin out of it so I it can be on by default & won’t need my attention.
Here it is: plugin (more...)

Vagrant + Ansible + Oracle

So, I finally got my act together and created the repositories I’ve been meaning to create for ages, to automatically spin up a VM running Oracle. They are: and uses Vagrant to provision the machine, and then Ansible to automatically provision Oracle. The readme’s for each repository should (hopefully) be enough to get […]

Indexing in Oracle, Fragmentation

I just uploaded my slides from Collaborate 2017 to Slideshare, but also, the findings missing from my slide deck I used for Oak Table World on War of the Indices- Oracle and SQL Server.  Feel free to download them here.

As I tested out Oracle vs. SQL Server Index performance, I ran across this great script to check for fragmentation from Franck Pachot.  You’ll need to simply update (more...)

Change Repository DB Connection in EM 13c

Sometimes it’s hard to find what you’re looking for in the Oracle documentation or on MOS if you don’t already know what exactly to search for. This happened to me while trying to find out  how the method of changing the DB connection for the EM repository changed in 13c. So I thought my findings […]