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.

My new website about reverse engineering challenges/exercises/problems/tasks:

My new website about reverse engineering challenges/exercises/problems/tasks:

You’re On A Roll(back)

"I know one thing for certain; it is much harder to tell whether you are lost than whether
you were lost, for, on many occasions, where you are going is exactly where you are.

Oracle ASM Rebalance – Turn it up. To 11?

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


If you’ve ever seen or heard of the movie This is Spinal Tap then you have likely heard the phrase href="" target="_blank">Turn it up to 11.

Why bring this up?

Upgrading Oracle with Unknown Errors

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


I recently experienced a problem when upgrading an old Oracle database to that had no matches in a My Oracle Support (MOS) or Google search. The problem presented itself initially when upgrading as the following error was reported by the upgrade script:

Dynamic MySQL Credentials with Vault

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

Recently I have been looking at the href="" target="_blank">Vault project as a means to manage secrets for applications and end-users. One of the use cases that immediately drew my attention was the ability to create dynamic role-based MySQL credentials.

Why Dynamic MySQL Credentials?

There are a few reasons why dynamic credentials would be beneficial, all of which can be handled by Vault, including:

Pragma UDF – Some Current Limitations

There are currently some limitations to when pragma UDF will speed up your calls to PL/SQL functions.

In my post introducing the new pragma UDF feature of Oracle 12c I explained how it can be used to reduce the impact of context switching when you call a PL/SQL function from SQL.

Five Posts that Made Us Think

What makes a great blog post? We all have our pet criteria: sharp prose. Enlightening content. Stunning photos. (“Lots of GIFs?” Sure, why not?) Beyond its style or tone, a standout post invites us to take a peek into another person’s home or field of expertise, and offers a glimpse of that individual’s mind at work.

Troubleshooting Another Complex Performance Issue – Oracle direct path inserts and SEG$ contention

Here’s an updated presentation I first delivered at Hotsos Symposium 2015.

It’s about lots of concurrent PX direct path insert ant CTAS statements that, when clashing with another bug/problem, caused various gc buffer busy waits and enq: TX – allocate ITL entry contention. This got amplified thanks to running this concurrent workload on 4 RAC nodes:


I used to think that a user with SELECT ANY TABLE and SELECT ANY DICTIONARY could see anything in a database. I found out today that these 2 privileges do not allow you to SELECT from another user’s sequence. You can see what I mean in the example below, which I tested in an Oracle 11.1 database.

view counter