• 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: v$sqlstats

March 4, 2019 Uncategorized

Use V$SQLSTATS not V$SQL to find expensive SQL

It’s a holiday here today in Perth, so a very brief blog post because I’ve been busy doing other things

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
  • New Year ... new idea ... new channel
  • Why you keep getting "ORA-01653: unable to extend table"
  • The death of UTL_FILE
  • No more stale statistics in 19c
  • Complex materialized views and fast refresh
  • APEX 20.2 comes to town (well, to my PC)
  • Connection shortcuts with a wallet
  • How long will the script take to run?
Blog at WordPress.com.