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

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

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

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

August 28, 2017 Uncategorized

12c Statistics on load–special cases

One of the cool features in 12c is the automatic collection of optimizer statistics when a table is either created

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.

Tweets by connor_mc_d

    Top Posts & Pages

    • How to do a GRANT on an entire schema
    • Why I blog
    • Why you keep getting "ORA-01653: unable to extend table"
    • Adding APEX 23.1 to your Database Free VM
    • No more stale statistics in 19c
    • How to TREAT data in a CLOB as JSON
    • Implementing dynamic partitions AND subpartitions
    • Bringing Multimedia back into 19c!
    • INITRANS grabs a little more space
    • How to generate random unique values
    Blog at WordPress.com.
    • Follow Following
      • Learning is not a spectator sport
      • Join 864 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