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

July 22, 2013 Uncategorized

12c invisible columns

As several bloggers have already pointed out, column order changes when you start playing with invisible columns, for example SQL>

Continue reading

July 13, 2013 Uncategorized

12c ddl logging

In new releases, its often the little things that really catch my attention. Like this one…. I love it SQL>

Continue reading

July 1, 2013 Uncategorized

Feeling raw about raw…

Its been well documented for a while that Oracle were not going to allow raw devices in 12….but this still

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

April 29, 2013 Uncategorized

Its not about the outage

My Oracle Support had a fairly lengthy outage today right in the middle of the Australian business day. But I’m

Continue reading

February 5, 2013 Uncategorized

Lob CACHE vs NOCACHE – impact on flashback logging

I was doing some work for a client, and LOB processing seemed incredibly slow. After some poking around, it appears

Continue reading

Posts navigation

«Previous Posts 1 … 20 21 22

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

    • SQL engine and PL/SQL functions
    • 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
    • A new use for DML error logging
    • How to TREAT data in a CLOB as JSON
    • How to generate random unique values
    • Getting a dog improved my productivity
    • Automatically generate audit capture for tables
    • Archives
    Blog at WordPress.com.
    • Follow Following
      • Learning is not a spectator sport
      • Join 847 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