view counter

Database Feed

Oracle Database, Oracle 10g, Oracle 11g, Oracle XE, Oracle RAC, Oracle Instant Client, Oracle Data Guard and Oracle Exadata resources, news, and support articles.

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

class="l-submain-h g-html i-cf">


This Log Buffer Edition covers some of the niftiest blog posts from Oracle, SQL Server and MySQL.


S-EU Safe Harbor Framework Invalidated – It’s time to Love Your Data!

class="l-submain-h g-html i-cf">

Pythian has been closely following the developments in the EU relating to the invalidation of the US-EU Safe Harbor Framework.

On Friday, November 6, 2015, the European Commission issued guidance on the cross-border data transfer issues. This guidance spoke more to “alternative transfer tools” available to legitimize data flows to jurisdictions deemed “not adequate,” like the United States.

If you do transfer data and rely on Safe Harbor principles, we recommend you:

Wanted: RDBMS superpower summary for app developers

At last night's WWCode Cincinnati panel, I recommended that developers talk to their DBA about what advanced capabilities their RDBMS can offer, so that they don't end up reimplementing functionality in the app that are already available (better and more efficiently) in the database itself. Devs can waste a lot of effort by thinking of databases as dumb, inert data boxes.

I was asked an excellent question: "Where can a dev quickly familiarize herself with what those capabilities are?" My answer was, "Um."

Oracle OpenWorld Reflections – Word on the Street

This was my fourth Oracle OpenWorld (having first attended way back in 2011) and, whatever anyone says about this conference, you can be sure that it is always quite an experience, and I am grateful for the chance to attend. Now with a few under my belt, I’m particularly interested in the differences year to year […]

TABLE ACCESS INMEMORY FULL – but there may be more

While preparing to teach a class this week I have had the time to look into the In Memory (cost) option a bit closer. I noticed a few interesting things along the way and would like to share one of these here.


One of the questions I was asking myself was:

“What happens if I scan segments that are within the IM area, and some are not?”


You can use one of these to link an exception name with an Oracle error number. Once you have done this, you can use the exception name in the exception block which follows the declaration. You can see what I mean in the example below, which I tested in an Oracle 11.2 database. First I set up a table so I could test the procedure I was going to create:

Little Things Doth Crabby Make – Part XVIV: Enterprise Manager 12c Cloud Control Install Problem.

This is a short post to help out any possible “googlers” looking for an answer to why their EM Cloud Control install is failing in the make phase with

Note, this EM install was taking place on an Oracle Linux 7.1 host.

The following snippet shows the text that was displayed in the dialogue box when the error was hit:


A short video that I did at the OTN lounge at RMOUG a couple of years ago has just been posted on YouTube. It’s about the improvements that appear in histograms in 12c. I’ll move this link into a more suitable posting in the near future.


New Theme: Dyad

This Theme Thursday, we’re introducing a new free theme: Dyad.


Dyad pairs text and images in a balanced, dynamic layout, making it perfect for blogs where words and photographs need equal weight. Featured Images are displayed in different sizes and dimensions, depending on screen size and device.

Media player in Apex

Quite a long time ago I made a collection of MP3s available from our Apex website and made them playable within the browser using Google’s shockwave player, using code like this:

view counter