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
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”