• About
  • Archives
  • 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
August 15, 2019 Uncategorized

No more stale statistics in 19c

There is an odd contradiction that we all encounter for most databases, especially if they are predominantly used during the

Continue reading

August 8, 2019 Uncategorized

Plugzilla!

Cloning a pluggable database takes time, and for environments where you’d like to use clones as part of unit testing,

Continue reading

August 7, 2019 Uncategorized

Autonomous Transaction Processing – your slice of the pie

I grabbed the following screen shot from a slide deck I’ve been giving about Autonomous Transaction Processing (ATP). It shows

Continue reading

August 5, 2019 Uncategorized

Take a COPY out of SQLcl’s book

As the world continues to get smaller, it makes sense for all databases to be defined to handle more than

Continue reading

July 29, 2019 Uncategorized

Statistics on Load

One of the talks I gave recently on the Groundbreaker Yatra tour was on the changes that arrive with the

Continue reading

July 23, 2019 Uncategorized

It’s back!

Yes indeed! Now that the dates and times are available for OpenWorld 2019, then it is naturally time for the

Continue reading

July 8, 2019 Uncategorized

HIGH_VALUE (and other LONG columns) revisited

Just a quick post to ensure people don’t get caught out by a recent “trick” I saw on an AskTOM

Continue reading

Posts navigation

«Previous Posts 1 2 3 4 5 … 74 Next Posts»

Over 500 posts …

Connect with me

  • 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

Enter your email address to follow this blog and receive notifications of new posts by email.

Top Posts & Pages

  • NULL's vs NOT NULL's and Performance
  • All the OpenWorld 2019 downloads!
  • Shirts of OpenWorld
  • Long running scheduler jobs
  • Updating indexes with partition maintenance
  • The holistic SQL tuning series
  • Attribute clustering….super cool
  • Active and Inactive Sessions
  • Cross-platform database migration
  • The death of UTL_FILE
Blog at WordPress.com.
Learning is not a spectator sport
Blog at WordPress.com.
Cancel