• About
  • All Posts
  • 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

Tag: performance

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

June 5, 2020 Uncategorized

MAX_IDLE_BLOCKER_TIME to stop locking problems

We’ve all been there … You’re trying to save some changes to the database, and no matter what you try,

Continue reading

May 1, 2020 Uncategorized

Free In-memory in Oracle Database 19c

There has always been a bit of a Catch-22 with some of the really cool options in the Oracle Database.

Continue reading

April 24, 2020 Uncategorized

SQL Plus and the ROWPREFETCH parameter

Need to get a bunch from rows out of the database? Most people are aware of the ARRAYSIZE parameter to

Continue reading

February 29, 2020 Uncategorized

Simple transaction benchmark on Oracle Database

Man, it gets my goat when people start pontificating nonsense on Twitter. Yeah, I know, I know, I shouldn’t get

Continue reading

November 19, 2019 Uncategorized

Larger number of Exadata storage indexes

We had a question on AskTOM inquiring about how to handle the issue of only 8 storage indexes being possible

Continue reading

October 24, 2019 Uncategorized

The holistic SQL tuning series

I did a set of articles for Oracle Magazine on a more holistic view of SQL tuning. What do I

Continue reading

October 3, 2019 Uncategorized

The definition of proof

One of the pieces of advice that I often see on the ‘net is that undo space is somehow this

Continue reading

Posts navigation

1 2 3 … 6 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.

Top Posts & Pages

  • PL/SQL in 21c gets amazing new loop iterators
  • 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
  • APEX 20.2 comes to town (well, to my PC)
  • Cross-platform database migration
  • Connection shortcuts with a wallet
  • Complex materialized views and fast refresh
  • The death of UTL_FILE
  • SQL statements using literals
Blog at WordPress.com.
Learning is not a spectator sport
Blog at WordPress.com.
Cancel