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

Tag: performance

a picture from the rear of a mclaren sports car
December 6, 2021 Uncategorized

SQL*Plus shortcut for fast data unload

I published a video a few days ago on the various tools you can use to unload data out of

Continue reading

congested traffic across 4 lanes
November 14, 2021 Uncategorized

The big table dilemma – what about transaction rates?

Yesterday I posted some demonstrations of the impressive power of indexes in relational databases for data retrieval even when those

Continue reading

a truck overfilled with cut logs driving on the highway
November 13, 2021 Uncategorized

When does a table become too big?

I happened across an interesting thread on Twitter today which posed the question about when you should intervene with alternative

Continue reading

September 15, 2021 Uncategorized

SQL trace on your cloud database

There are so many great performance monitoring tools that have come along in the Oracle Database since 10g – things

Continue reading

August 6, 2021 Uncategorized

We killed sequence contention!

A few months back I gave a talk on the importance of good physical design if you need to meet

Continue reading

July 19, 2021 Uncategorized

Drop all baselines

Just a quick tip today on doing a “reset” on your optimizer environment. SQL Plan Baselines are an awesome tool

Continue reading

July 12, 2021 Uncategorized

19.11 Database Release Update

I tweeted about a particular bug fix that interests me for 19.11, namely a critical fix for Flashback Data Archive

Continue reading

July 5, 2021 Uncategorized

CURSOR_SHARING and ORDER BY

AskTom regular Rajeshwaran Jeyabal posted an interesting comment a few days ago about the use of CURSOR_SHARING when it comes

Continue reading

19c scheduler and jobs
June 24, 2021 Uncategorized

PL/SQL performance in 19c

I gave a talk at Kscope21 yesterday about common mistakes that we make during the database development cycle. To kick

Continue reading

June 4, 2021 Uncategorized

Parallel DML and locking – going manual

Generally speaking, if you have a giant chunk of data over “here”, and you need to load it into a

Continue reading

Posts navigation

«Previous Posts 1 2 3 4 … 9 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
    • Getting a dog improved my productivity
    • Automatically generate audit capture for tables
    • Archives
    Blog at WordPress.com.
    • Follow Following
      • Learning is not a spectator sport
      • Join 846 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...