• 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: dbms_stats

random dice toss
September 1, 2020 Uncategorized

Frequency histogram – where did that estimate come from?

Frequency histograms in any version of Oracle are pretty cool things, so whenever you have a distribution of data that

Continue reading

August 15, 2019 Uncategorized

No more stale statistics in 19c

There is an odd contradiction that we all encounter for most databases, especially if they are predominantly used during the

Continue reading

July 29, 2019 Uncategorized

Statistics on Load

One of the talks I gave recently on the Groundbreaker Yatra tour was on the changes that arrive with the

Continue reading

February 18, 2019 Uncategorized

Statistics on Object tables

Way back in Oracle 8.0 we introduced the “Object-Relational” database, which was “the next big thing” in the database community

Continue reading

January 16, 2019 Uncategorized

EXPORT not GATHER with DBMS_STATS

Just a short post today on something that came in as a question for the upcoming Office Hours session which

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.

Top Posts & Pages

  • PL/SQL in 21c gets amazing new loop iterators
  • How to do a GRANT on an entire schema
  • Solving a John Conway puzzle with SQL
  • APEX 20.2 comes to town (well, to my PC)
  • No more stale statistics in 19c
  • How to upgrade to Oracle 19.8 on Windows
  • Pluggable database and restricted sessions
  • MERGE and ORA-30926
  • The death of UTL_FILE
  • DBMS_JOB and 19c - code changes needed
Blog at WordPress.com.