• About
  • All Posts
  • The Podcast!
  • 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
  • The Podcast!
a cassette tape with the tape unravelling out of it
March 28, 2022 Uncategorized

Block recovery a lot easier than I thought

I tweeted this snippet the other day because to be honest I was just overjoyed about being able to get

Continue reading

two hands shuffling a deck of cards in close up
March 22, 2022 Uncategorized

When re-ordering columns is warranted

Nearly 10 years ago(!!!) I blogged about how you can toggle columns to invisible and back again as a means

Continue reading

a truck overfilled with cut logs driving on the highway
March 10, 2022 Uncategorized

Don’t run tight on PGA

The database on my laptop seemed slow this morning. Normally I would put this down to the fact that I’ve

Continue reading

two identical sheep
March 7, 2022 Uncategorized

After you clone your pluggable database

Recently I cloned one my (pluggable) databases to a throwaway copy so that I could do some testing of an

Continue reading

soapy hands washing under a running tap
March 2, 2022 Uncategorized

Cleaner DDL than DBMS_METADATA

Most of us with any kind of longevity in the Oracle world will remember the days when we wrote our

Continue reading

a close up of a sleeping dog with its tongue hanging out
February 16, 2022 Uncategorized

INITRANS grabs a little more space

INITRANS defines how many concurrent transactions you can have within a single datablock for a segment (table, materialized view, etc).

Continue reading

February 11, 2022 Uncategorized

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

Continue reading

February 6, 2022 Uncategorized

A new dictionary view for privileges

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

Continue reading

February 2, 2022 Uncategorized

Awesome DATE / TIMESTAMP enhancement in Autonomous Database

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

Continue reading

January 31, 2022 Uncategorized

Silent data corruption – constraints spanning multiple rows

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

Continue reading

Posts navigation

«Previous Posts 1 2 3 4 … 70 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

  • How to do a GRANT on an entire schema
  • Is my table marked for archive?
  • Why you keep getting "ORA-01653: unable to extend table"
  • Connection shortcuts with a wallet
  • No more stale statistics in 19c
  • How to TREAT data in a CLOB as JSON
  • How to generate random unique values
  • Don't run tight on PGA
  • Pluggable database and restricted sessions
  • DBMS_JOB - the joy of transactions
Blog at WordPress.com.
Learning is not a spectator sport
Blog at WordPress.com.
  • Follow Following
    • Learning is not a spectator sport
    • Join 811 other followers
    • Already have a WordPress.com account? Log in now.
    • Learning is not a spectator sport
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...