• 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

January 25, 2023 Uncategorized

SQL engine and PL/SQL functions

A common pattern I see in database code is the use of a PL/SQL package to hold constants to be

Continue reading

November 30, 2022 Uncategorized

The cost of DBMS_PARALLEL_EXECUTE

I had an inquiry about the performance of DBMS_PARALLEL_EXECUTE today from a customer. Whilst the utility (as the name suggests)

Continue reading

August 8, 2022 Uncategorized

A simple benchmark harness

At my physical design talk at this year’s Yatra tour in India, one of the demos I do is multiple

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

July 8, 2022 Uncategorized

PL/SQL – choosing the BEST data type

Just a little bit of Friday fun with PL/SQL data types for this post. Let’s explore the performance differences when

Continue reading

a collection of crushed plastic bottles ready for recycling
May 30, 2022 Uncategorized

Recycling saves the planet but maybe not your database

The recyclebin is a very cool feature in the Oracle Database, and a great “Get of our jail free” card

Continue reading

a woman at a laptop frustrated with coding
April 13, 2022 Uncategorized

My poor developers! PLSQL is going to be so hard on them!

So I started all of this by talking about how PLSQL is going to give you a performance boost, just

Continue reading

the end of an ethernet network cable
April 12, 2022 Uncategorized

A little bit of PLSQL and a little bit of network

So after my post yesterday about PL/SQL being a no-brainer to get an easy boost to application performance, there was

Continue reading

a running cheetah
April 11, 2022 Uncategorized

A little bit of PLSQL can be a huge win

I rarely blog about PLSQL for a very simple reason. It quickly becomes like Halloween night because all the ghouls

Continue reading

a truck overfilled with cut logs driving on the highway
March 10, 2022 Uncategorized

Don’t run tight on PGA

The database on my laptop seemed slow this morning. Normally I would put this down to the fact that I’ve

Continue reading

Posts navigation

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

    • 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
    • 19c Express Edition #JoelKallmanDay
    • How to TREAT data in a CLOB as JSON
    • The phantom tablespace
    • Connection shortcuts with a wallet
    • Automatically generate audit capture for tables
    • ORDS upgrades are so easy
    • HIGH_VALUE (and other LONG columns) revisited
    Blog at WordPress.com.
    • Follow Following
      • Learning is not a spectator sport
      • Join 852 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...