Category Archives: Oracle

Is Virtualization Worth It?

Before planning any project, the first thing I like to do is ask what outcome are we trying to achieve here? A case in point is virtualization, the holy grail of IT du jour. A virtualized infrastructure is not a … Continue reading

Posted in Business, Linux, Oracle | 2 Comments

Coherence

I am still a little mind-blown by yesterday’s intensive introduction to Coherence. I had thought of it as just a glorified caching layer, as that is pretty much how I have seen it used, but it is in fact astonishingly … Continue reading

Posted in Coherence, Oracle, Random thoughts | Leave a comment

To the max!

Today is all about Extreme Transaction Processing. Should be an interesting day!

Posted in Oracle | 2 Comments

Extprocs in OCaml

An external procedure or EXTPROC is a technique for calling C or other native code from SQL in Oracle. Why might you want to do this? To interface to a 3rd party system for which there is only a C … Continue reading

Posted in Linux, Ocaml, Operation Foothold, Oracle | 2 Comments

Stacks and other stuff

An interesting coincidence: I happened to mention Forth in my last post, and I have also been looking at Tenacious C, a new (sadly Windows-only for now) C IDE with some innovative visualization of a program’s memory use. They’ve a … Continue reading

Posted in Ocaml, OCIML, Operation Foothold, Oracle, Random thoughts | Leave a comment

Why

A few thoughts on why I decided to start working on an open source project: I enjoy working in OCaml (functional languages in general, in fact), and need a project to work on that I can take in any direction … Continue reading

Posted in Ocaml, OCIML, Oracle, Python, Random thoughts | Leave a comment

Scala Quickstart for Oracle DBAs

For the benefit of my fellow DBAs, here is a quick guide to getting up and running with Scala, a language that is gaining a lot of interest recently. The aim of the exercise is to produce the simplest possible … Continue reading

Posted in Operation Foothold, Oracle, Scala | 7 Comments

Jack of all trades → Master of Disaster.

When I got started in the industry†, like many people I was a generalist; designing and programming GUIs, network services, systems and database administration, even a bit of Photoshop, account management (the other sort of clients!) and end-user support. I … Continue reading

Posted in Business, C++, f#, Ocaml, Oracle, Random thoughts, Scala | 3 Comments

OCI*ML: Ref Cursors and Raw Messages

A few more additions to OCI*ML: Support for ref cursors and binding OUT variables by name as well as by position (see below) Support for type RAW in AQ (see below) oci_version function returns a tuple of (major version, minor … Continue reading

Posted in Ocaml, OCIML, Oracle | 1 Comment

OCI*ML: 100× Faster with Bulk Operations

Continuing with my fixation on reducing the number of network roundtrips in OCI*ML I have enhanced the orabindexec function to perform bulk DML, that is to say, batching many similar INSERT, UPDATE or DELETE statements on the same table into … Continue reading

Posted in Ocaml, OCIML, Oracle | Leave a comment