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

December 13, 2021 Uncategorized

Detecting if your database is multitenant

Just a quick tip for this post today. I had a question come in asking how to detect whether a

Continue reading

December 7, 2020 Uncategorized

The invisible restore point

I regularly create and drop tablespace on my databases here at home, mainly because they are obviously not used in

Continue reading

January 13, 2020 Uncategorized

Avoid orphaned Lockdown Profiles

Most administrators are now aware of the lockdown profile facility in the Oracle database (available since 12c). They allow a

Continue reading

December 19, 2019 Uncategorized

Why all pluggable database names should be unique

A quick tip just in time for Christmas I logged on to my database this morning, and things just didn’t

Continue reading

August 8, 2019 Uncategorized

Plugzilla! A pluggable cloning utility

Cloning a pluggable database takes time, and for environments where you’d like to use clones as part of unit testing,

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

  • Powerpoint hack for tech presenters
  • Why you keep getting "ORA-01653: unable to extend table"
  • How to do a GRANT on an entire schema
  • Juice up your JSON on Autonomous
  • No more stale statistics in 19c
  • Automatically generate audit capture for tables
  • Digging deeper into SQL under APEX
  • A justification for referential integrity constraints
  • Don't run tight on PGA
  • We killed sequence contention!
Blog at WordPress.com.
  • Follow Following
    • Learning is not a spectator sport
    • Join 821 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