• 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!
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

January 25, 2022 Uncategorized

New Podcast Episode – The Optimizer with Nigel Bayliss

No topic quite gets emotions rolling as much as the Oracle Query Optimizer. The fact that a piece of software

Continue reading

January 17, 2022 Uncategorized

Careful with SQL*Plus and SQL_ID feedback

Just a quick word of warning on a cool feature of SQL*Plus that came along from 18c onwards. I’ve posted

Continue reading

January 13, 2022 Uncategorized

UTL_HTTP, secure hosts and ORA-24263 certificate errors

Security eh? It is just one of those little things that is good to have in a database. The “problem”

Continue reading

January 6, 2022 Uncategorized

New Podcast Episode! Why every DBA should learn APEX

The very name of the product – Application Express (APEX) – suggests that this is a tool solely for building

Continue reading

a christmas tree
December 23, 2021 Uncategorized

Wrapping up 2021

Last year I started my 2020 wrap up with “With all the challenges of 2020…” with a perhaps overly optimistic

Continue reading

the logo for log4j
December 22, 2021 Uncategorized

Twas the night before … log4j

‘Twas the week before Christmas, and all through the world, Many developers were stirring, as a nightmare unfurled. The log4j

Continue reading

Posts navigation

«Previous Posts 1 … 4 5 6 7 8 … 73 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.

Tweets by connor_mc_d

    Top Posts & Pages

    • SQL engine and PL/SQL functions
    • How to do a GRANT on an entire schema
    • Why you keep getting "ORA-01653: unable to extend table"
    • No more stale statistics in 19c
    • A new use for DML error logging
    • How to TREAT data in a CLOB as JSON
    • How to generate random unique values
    • Automatically generate audit capture for tables
    • Getting a dog improved my productivity
    • Modifying tables without losing materialized views
    Blog at WordPress.com.
    • Follow Following
      • Learning is not a spectator sport
      • Join 847 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...