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

June 5, 2020 Uncategorized

MAX_IDLE_BLOCKER_TIME to stop locking problems

We’ve all been there … You’re trying to save some changes to the database, and no matter what you try,

Continue reading

June 26, 2018 Uncategorized

More triggers are better

Yes, you heard me correctly. If you have got one trigger on a table, then you might be surprised to

Continue reading

April 13, 2018 Uncategorized

Concurrency … the path to success and the path the failure

Let’s face it. Concurrency is a good thing when it comes to database applications. After all, if there is only

Continue reading

October 19, 2016 Uncategorized

Locked rows and lunch breaks ? A simple fix

Even in the new world of stateless web applications, from time to time we still come across the “lunch break

Continue reading

February 1, 2016 Uncategorized

Forever is a long time

It’s interesting that we still see lots of code out “in the wild” that leans itself to taking forever. Now

Continue reading

June 8, 2013 Uncategorized

can you lock part of a table ?

I should stress that this is all well covered in the documentation, but it was something I stumbled upon just

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

    • The new forums
    • How to do a GRANT on an entire schema
    • The simple fix to date queries
    • How to TREAT data in a CLOB as JSON
    • Generating INSERT scripts that run fast!
    • Connection shortcuts with a wallet
    • Digging deeper into SQL under APEX
    • Why you keep getting "ORA-01653: unable to extend table"
    • How to generate random unique values
    • No more stale statistics in 19c
    Blog at WordPress.com.
    • Follow Following
      • Learning is not a spectator sport
      • Join 848 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