Martins Blog

Oracle

Compile DBD::Oracle 1.23 with Oracle 11.2 client

This article discusses how to compile DBD::Oracle for Oracle client 11.2 x86-64 on Linux (Fedora 12…
Policy managed databases

This is a long overdue reply to an email Mark Bobak sent to the oracle-l mailing…
Upgrade Clusterware 10.2 to 11.2

This post is about upgrading Oracle Clusterware 10.2.0.4 on Oracle Enterprise Linux 5.4 x86-64. The setup…
Hide SQL query in spool file

This is a common problem I have: I need to generate a SQL script to be…
My first contact with the log miner

I have never really played with log miner, but used it many times implicitly for streams.…
Restore table statistics

UPDATE 230306 this post was originally written in December 2009. The examples have been verified &…
Recreate the standby controlfile when using ASM

This is in reply to some work I was supposed to carry out over the weekend…
Explain plan doesn’t peek at variables

I was trying to experiment with the 11g SQL Plan Management feature when stumbing across this.…
UKOUG Conference-session review part 3

The final installment of this series deals with Tom Kyte’s top 10 features in 11.2 and…
Let there be multipathing (when there wasn’t before)

One of the projects I was working on recently couldn’t be finished as it should have…