Top 60 Oracle Blogs

Recent comments

March 2015

Video Blogging the Squarespace Bedford

No one can serve two masters we are told, but it's common in Squarespace to find one data element serving two purposes. Pastor Taylor Birkey of The Edge Church in Aurora was stymied recently by a thumbnail image that he simultaneously wanted and didn't want in connection with a video blog of sermons in the church.

The Desired Look

The church maintains a blog just for sermons. Videos are posted to Youtube, and then a blog post is created for each video. The top content item in each post is a Squarespace video block linked to the Youtube video. Figure 1 shows the design, which is in the Bedford template.

Video Blogging the Squarespace Bedford

It's trouble when you serve two masters, and it's often trouble when a data
element serves two purposes. I help a pastor avoid trouble by placing his
sermons above the fold in a video blog done in...

Read the full post at

12c Parallel Execution New Features: Concurrent UNION ALL - Part 2

In the first part of this series I've focused on the parallel degree chosen by the optimizer when dealing with the new concurrent UNION ALL feature.I've shown that for the variant with serial branches only in the UNION ALL in principle the number of branches dictates the parallel degree determined, even in cases of more complex plans that mix such a serial branch only UNION ALL operator with some other parallel stuff for example via a join.In this part I'll focus on the runtime behaviour of the feature, but before doing so let me show you what happens if you start mixing serial and parallel branches in the UNION ALL, like that (using the identical table setup as in the previous part):

select count(*) from (

Extra session at OUG Ireland – Oracle Lego.

I’m now doing a second session at OUG Ireland 2015. {This is because one of the accepted speakers had to drop out – it sometimes happens that, despite your best intentions, you can’t make the conference and it is better to let them know as soon as you can, as they did}. This will be a talk called “Oracle Lego” and it is one I put together a couple of years ago when I decided to try and do more introductory talks – talks aimed at those who are not {yet} experts and who I think tend to get ignored by most conference and user group agenda. So it is aimed at those new to oracle or experts in other areas who have never really touched on the subject.

Flashback Logging

One of the waits that is specific to ASSM (automatic segment space management) is the “enq: FB – contention” wait. You find that the “FB” enqueue has the following description and wait information when you query v$lock_type, and v$event_name:

PeopleTools 8.54: Performance Performance Monitor Enhancements

This is part of a series of articles about new features and differences in PeopleTools 8.54 that will be of interest to the Oracle DBA.

Transaction History Search Component

There are a number of changes:

Flashback logging

When database flashback first appeared many years ago I commented (somewhere, but don’t ask me where) that it seemed like a very nice idea for full-scale test databases if you wanted to test the impact of changes to batch code, but I couldn’t really see it being a good idea for live production systems because of the overheads.

Oracle Internals

Useful list of Oracle Conferences and Call For Papers

Do you want to know what Oracle conferences are run, where they are and when? Do you present (or are thinking of presenting) and want to know when the call for papers is open?

Then go and look at Jan Karremans’ excellent page on oracle conferences.

It lists most (all?) of the European and US conferences and is a really useful reference – I’ve not come across a similar, maintained list. The below is a static screen shot of part of the list, current of today – but visit the page to see the full, maintained list.

Jan's conference list

Converting non-CDB database to a PDB when TDE is in use

Converting a non-CDB database to a PDB is a rather straightforward process. However once TDE (Transparent Data Encryption) gets involved certain things become not so obvious so I've decided to write a small guide on how to accomplish that. In order for a non-CDB database to be converted to a PDB it's version needs to be at least

Encryption Wallet Location

My encryption wallet location is set to the following (sqlnet.ora):

(DIRECTORY = /u01/app/oracle/admin/$ORACLE_SID/wallet/tde)

Create a non-CDB database

Let's start by creating a non-CDB database. I will call this database db1 and it will later be converted to a pluggable database called pdb1:

dbca -silent \
-createDatabase \
-templateName New_Database.dbt \
-gdbName db1 \