dba – Learning is not a spectator sport

Extended VARCHAR2 and the hidden LOB

In 12c, there was much rejoicing when VARCHAR2 columns could be extended from beyond their current 4000 byte limit to

One of the very cool features from 12.2 onwards is that the vast majority of segment operations that require rewrite

I’ve done a lot of presentations over the years, written a ton of blog posts, and over the past 5

I regularly create and drop tablespace on my databases here at home, mainly because they are obviously not used in

Most people know AskTOM as the go-to resource for getting answers to the most common and sometimes the most tricky

Space management used to be hard Way back in the good old days…In fact, before I continue, rest assured that

If you are loading a data warehouse or similar environment where your default approach would probably be to compress all

Here’s a “gotcha” brought to my attention by one of our AskTOM readers. I’ve mentioned in the past that DBMS_JOB,

When you connect to your Autonomous Database, you get to choose from some predefined services. The services available depends on

The other day as my PC popped up its usual “Hey, you really should look at buying a bigger disk”