• 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: sql tuning

November 11, 2022 Uncategorized

I did not write this blog post

In fact…no-one wrote this blog post! Here’s a little bit of fun for you. I was doing my normal doom

Continue reading

July 12, 2022 Uncategorized

Digging deeper into SQL under APEX

For the many cases, simply having an EXPLAIN PLAN function will do the job when it comes to tuning SQL.

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

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

July 6, 2021 Uncategorized

New Podcast Episode! Lets talk about SQL Tuning

There is a million books, blogs, presentations etc about SQL Tuning. But it’s time for a different perspective. SQL Tuning

Continue reading

April 12, 2021 Uncategorized

Better performance when querying the V$ views

I’m a big fan of giving developers the tools they need to tune their applications in Production if that is

Continue reading

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

    • The new forums
    • How to do a GRANT on an entire schema
    • The simple fix to date queries
    • How to TREAT data in a CLOB as JSON
    • Generating INSERT scripts that run fast!
    • Connection shortcuts with a wallet
    • Why you keep getting "ORA-01653: unable to extend table"
    • How to generate random unique values
    • No more stale statistics in 19c
    • Digging deeper into SQL under APEX
    Blog at WordPress.com.
    • Follow Following
      • Learning is not a spectator sport
      • Join 848 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...