Subscribe

Author Profile

Connor McDonald
Developer Advocate

Connor McDonald is a former Oracle ACE Director who has joined the Oracle Developer Advocates Team. Over the past 25 years, he has worked with systems in Australia, the United Kingdom, Southeast Asia, Western Europe, and the United States. He has co-authored three books and has been a popular speaker at Oracle conferences around the world, specializing in topics regarding the database engine and PL/SQL. 

A Higher-Level Perspective on SQL Tuning, Part 4

Common causes for poorly performing SQL By Connor McDonald August 12, 2019 In my previous article on SQL tuning, I discussed the importance of taking the correct...

A Higher-Level Perspective on SQL Tuning, Part 3

Tune poorly executing SQL statements. By Connor McDonald July/August 2019 In my previous article on SQL tuning, I discussed the mechanisms for identifying SQL...

The Importance of Data Types

The following steps demonstrate how to use the V$SQL PROGRAM_ID and PROGRAM_LINE# columns to track SQL back to a PL/SQL stored program unit. To see how an EXPLAI...

A Higher-Level Perspective on SQL Tuning, Part 2

Identifying and diagnosing poorly performing SQL By Connor McDonald May/June 2019 In my previous article on SQL tuning, I discussed the importance of stepping back...

A Higher-Level Perspective on SQL Tuning

The commonly missed first steps of tuning a SQL statement By Connor McDonald March/April 2019 Fire up your favorite search engine, enter “SQL tuning” as the search...

A Higher-Level Perspective on SQL Tuning, Part 2, Listing 4

Listing 4: The SELECT * FROM LOOKS_SO_INNOCENT query expanded via DBMS_UTILITY SQL> variable c clob SQL> begin 2 dbms_utility.expand_sql_text 3 ...

A Higher-Level Perspective on SQL Tuning, Part 2, PL/SQL

Tracking SQL back to a PL/SQL stored program unit The following steps demonstrate how to use the V$SQL PROGRAM_ID, and PROGRAM_LINE# columns to track SQL back to...

A Higher-Level Perspective on SQL Tuning, Part 2, Listing 1

The V$SQL performance view lists SQL statements in the shared SQL area and presents numerous performance measurements alongside each. Listing 1: V$SQL...

Are We All on the Same Page?

Pagination of data can make (or break) your database. By Connor McDonald October 18, 2018 For as long as user-facing computer applications have existed, there has...