Learning is not a spectator sport

V$SESSION_LONGOPS and parallel query

For pretty much as long as I can remember, the view V$SESSION_LONGOPS has existed. It has a suite of columns

So I tweeted this out on Friday and this reflects one of my joys with working with Oracle technology. The

Date management is a commonly encountered issue when customers want to move their database to a cloud environment. If you

One of the toughest problems in database applications is validation of data that extends “across” rows. We have declarative constraints

No topic quite gets emotions rolling as much as the Oracle Query Optimizer. The fact that a piece of software

Just a quick word of warning on a cool feature of SQL*Plus that came along from 18c onwards. I’ve posted

Security eh? It is just one of those little things that is good to have in a database. The “problem”

The very name of the product – Application Express (APEX) – suggests that this is a tool solely for building

Last year I started my 2020 wrap up with “With all the challenges of 2020…” with a perhaps overly optimistic

‘Twas the week before Christmas, and all through the world, Many developers were stirring, as a nightmare unfurled. The log4j