Who's online

There are currently 0 users and 28 guests online.

Recent comments


5 ways to boost your career with Social Media


Photo by Kevin Dooley

If you are in the Bay Area tomorrow, Jan 27, come see myself, Yann Ropars and #141823;">Yury Velikanov talk about how to leverage social media to boost your career. We will be talking at Oracle head quarters at the NoCOUG/BIWA conference at #444444;">2:30 pm 

Why use social media as an IT technician? Because

Free Version of Delphix !

Delphix is now available for  30 day trial direct download ! ( if you would like a longer version please contact me at year trials and even indefinite trials  potential possible for partners, bloggers, Oracle Aces etc)

Just got to the

The Delphix download trial consists of 3 pre-configured virtual machines downloadable as OVA files

Inappropriate behaviour

You pick up little funny things in the day to day with Oracle.

Like this one when you try to drop a tablespace with a queue table in it:

drop tablespace MY_TSPACE including contents
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-24005: Inappropriate utilities used to perform DDL on AQ table

You would think that since you’ve asked to drop everything, that well…everything could be dropped, but no :-)

The solution here is to use DBMS_AQADM.DROP_QUEUE_TABLE (with force=true if necessary) to clean it out, and the re-issue your command.

Data Pump import makes me crabby

I’m sitting here watching the import of a moderately sized database via transportable tablespaces.  You know…the thing you use when a full export / import would be too slow, and this is meant to be … well…fast.

And fast it is.. until it reaches the following step:


Now understandably, there’s plenty of stats to import, so its fair that it should take a little while.  But a quick look at the SQL that’s being run, reveals something truly hideous.  You’ll see a succession of giant PL/SQL blocks, chock full of literals and row-by-row (slow by slow) processing.  Things like this:

FBI Bug reprise

I’ve just had cause to resurrect a blog note I wrote three years ago. The note says that an anomaly I discovered in wasfixed in – and this is true for the simple example in the posting; but a recent question on the OTN database forum has shown that the bug still appears in more complex cases.  Here’s some code to create a table and two indexes:

Top 3 criteria to choose a data virtualization solution 

mirror_reflection_ copy
Photo: Martin #000000;">Beardy (CC BY 2.0)

Data virtualization solutions also known as Copy Data Management (CDM), Copy Data Virtualization (CDV) and Data #222222;">Virtualization Appliances (DVA) are rising rapidly as over 100 of the Fortune 500 have adopted data virtualization solutions between 2010 and end of 2014.

Slow external table access

We had an interesting issue on, where users were reporting very slow performance on queries to external tables. When I tried to replicate the problem, everything seemed just fine, so I initially reported back the familiar "Well, it works on my PC" :-) [Just kidding]

Anyway, connecting by proxy to one of their accounts, did reveal the error, which suggested something to do with privileges.  A sql trace revealed that the performance was due to a query which appears to get the list of directories and their privileges:


the definition of which was:

STEM to STEAM, Andy Savage, and a manipulative huffpost ad that could have been great

Andy Savage gave a powerful and on-target keynote at the Collaborate Conference (Quest, OAUG, and IOUG #C14LV). There is a nice summary at , which I recommend. My favorite bit was point #7 : Art belongs in the same discussions as Science, Technology, Engineering and Mathematics (S.T.E.A.M., not S.T.E.M.).

Andy phrased his entire take, even the bits of irony, on calling for positive action.

This is in contrast to a recent huffpost manipulation:

xfinity customer service chat

MARK_: My Issue: An hour on the phone and three attempts to authorize my replacement equipment PKKVZQSMC ended with a hang-up while supposedly transferring me to a supervisor.

user MARK has entered room

analyst Cherry has entered room

Cherry: Hello MARK_, Thank you for contacting Comcast Live Chat Support. My name is Cherry. Please give me one moment to review your information.

Cherry: Hi! How are you doing today, Mark?

MARK_: read what I wrote

Day 3+ of UKOUG Tech 14

Sorry it’s taken a couple of days to finish off this series of blog posts on UKOUG Tech 14. I had expected to get some time on the trip back to write this, but as you’ll see if you keep reading, that really didn’t happen. So let’s go back to Day 3 of the conference.