• 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

May 26, 2021 Uncategorized

Why indexes are so fast at finding a key

Glance through any text book, blog post, video tutorial etc on the topic of database indexes and you’ll typically chance

Continue reading

May 17, 2021 Uncategorized

Blazingly fast documentation search with APEX

The Oracle documentation set is my bread and butter for day to day work. With AskTom questions, StackOverflow question, Einstein

Continue reading

May 13, 2021 Uncategorized

APEX_DATA_PARSER turbo boost!

One of the most common recommendations I’ll make to customers who post questions on AskTom is “Install APEX even if

Continue reading

April 30, 2021 Uncategorized

The performance report you are NOT using

Just a quick post today to inspire you to look further than the standard options for performance monitoring. Quiz most

Continue reading

April 13, 2021 Uncategorized

New Podcast Episode! Every index is a bug

Every database has indexes…but should they? In this episode, lets consider a different proposition. What if the indexes you have

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

January 27, 2021 Uncategorized

Datatype conversions – strange internal function

Perhaps the most famous (or infamous) performance tuning problem you’ll find spanning decades of blog posts when it comes to

Continue reading

January 11, 2021 Uncategorized

How long will the script take to run?

In a world where databases are now the norm, whereas distributing data via a CSV file used to be commonplace,

Continue reading

recycle bin
August 27, 2020 Uncategorized

How to make queries to DBA_FREE_SPACE faster

The other day as my PC popped up its usual “Hey, you really should look at buying a bigger disk”

Continue reading

July 24, 2020 Uncategorized

SQL tuning with Hashing and Sorting

Aggregation SQL is not all just primary key lookups, although some applications sadly see SQL as only useful in that

Continue reading

Posts navigation

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