DBMS_JOB – watching for failures
I had a friend point this one out to me recently. They use DBMS_JOB to allow some “fire and forget”
Being generous to the optimizer
In a perfect world, the optimizer would reach out from the server room, say to us: “Hey, lets grab a
Hacking together faster INSERTs
Most developers tools out there have some mechanism to unload a table into a flat file, either as CSV, or
Nostalgia and choosing your in-flight movie
First thing to note on this post. No tech content in this one. Just some nostalgia. Couple of days ago,
Partition loading in direct mode
Direct mode insert using the APPEND hint is a cool piece of technology that lets you load bulk data into
Raw partitions?
Here’s a quirky one for you. It can happen when you are dealing with a partitioned table where the partition
Take care with automatic indexes
This one came in via an AskTOM question. You need to be careful when disabling constraints that are underpinned by
