• About
  • All Posts
  • Playlists
  • Golden Oldies
Skip to content

Learning is not a spectator sport

  • 30 second guide to India
  • About
  • Archives
  • Golden Oldies
    • First match
    • Smart DBA
  • Playlists

Tag: dba

March 4, 2021 Uncategorized

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

Continue reading

February 19, 2021 Uncategorized

Free space requirements for ALTER TABLE

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

Continue reading

January 22, 2021 Uncategorized

New Year … new idea … new channel

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

Continue reading

December 7, 2020 Uncategorized

The invisible restore point

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

Continue reading

December 2, 2020 Uncategorized

The AskTOM multimedia experience!

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

Continue reading

October 7, 2020 Uncategorized

Why you keep getting "ORA-01653: unable to extend table"

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

Continue reading

October 2, 2020 Uncategorized

Compression default settings

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

Continue reading

19c scheduler and jobs
September 3, 2020 Uncategorized

DBMS_JOB and 19c – code changes needed

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

Continue reading

woman working on flexibility
August 31, 2020 Uncategorized

How to control resource usage on Autonomous

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

Continue reading

recycle bin
August 27, 2020 Uncategorized

How to make queries to DBA_FREE_SPACE faster

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

Continue reading

Posts navigation

1 2 3 … 17 Next Posts»

Over 500 posts …

Let’s connect

  • View connor_mc_d’s profile on Twitter
  • View connor_mc_d’s profile on Instagram
  • View connor-mcdonald-australia’s profile on LinkedIn
  • View UCVN7PnJnuKQ65QLmWjFvhiw’s profile on YouTube

Hi I'm Connor McDonald. I love playing with and exploring the Oracle database. But most of all I like seeing people succeed with the technology.
 
Subscribe for new posts by email.

Top Posts & Pages

  • Blockchain tables are here in 19c!
  • Archives
  • No more stale statistics in 19c
  • My APEX was fine and then it wasn't
  • How to do a GRANT on an entire schema
  • Pluggable database and restricted sessions
  • APEX 20.2 comes to town (well, to my PC)
  • Extended VARCHAR2 and the hidden LOB
  • Complex materialized views and fast refresh
  • Why you keep getting "ORA-01653: unable to extend table"
Blog at WordPress.com.
Learning is not a spectator sport
Blog at WordPress.com.
Cancel

 
Loading Comments...
Comment
    ×