• 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: 12c

November 10, 2020 Uncategorized

Faster software installations

Just a quick tip today thanks to the one of the readers on my blog. If you’re installing Oracle 12c

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

May 27, 2019 Uncategorized

DBMS_JOB – watching for failures

I had a friend point this one out to me recently. They use DBMS_JOB to allow some “fire and forget”

Continue reading

September 21, 2018 Uncategorized

Another little 12c improvement

You’ve got a huge table right? Massive! Immense! And then something bad happens. You get asked to remove one of

Continue reading

September 17, 2018 Uncategorized

Partial indexing – get the dictionary definitions right

Just a quick post to clear up some confusion that can be seen on the partial indexing capabilities in Oracle

Continue reading

January 24, 2018 Uncategorized

Identity columns in 12c … just a sequence ?

This question came to me over Twitter, so I thought I’d whip out a quick post on it   Yes,

Continue reading

September 18, 2017 Uncategorized

LOBs and tiny typos

This one caught me out – I was racing around looking for bugs, or parameter files, or hidden settings that

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

May 2, 2017 Uncategorized

Quick tip–identity columns

Lets say I’ve been reading about schema separation, and thus I am going to have a schema which owns all

Continue reading

April 18, 2017 Uncategorized

Transportable Tablespace–part 2

I did a little demo of sharing a tablespace between two databases a few days back – you can see

Continue reading

Posts navigation

1 2 3 … 6 Next Posts»

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 you keep getting "ORA-01653: unable to extend table"
    • No more stale statistics in 19c
    • 19c Express Edition #JoelKallmanDay
    • How to TREAT data in a CLOB as JSON
    • The phantom tablespace
    • Connection shortcuts with a wallet
    • Automatically generate audit capture for tables
    • ORDS upgrades are so easy
    • HIGH_VALUE (and other LONG columns) revisited
    Blog at WordPress.com.
    • Follow Following
      • Learning is not a spectator sport
      • Join 852 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
     

    Loading Comments...