• 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!
May 1, 2013 Uncategorized

Long overdue…

The OTN forums, which should be a plethora of knowledge and learning, were always hampered by the hideous interface. But,

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

April 29, 2013 Uncategorized

OUGN Norway Conference

The OUGN conference (held on a cruise ship) was an awesome experience and so professionally run by the committee.  I

Continue reading

April 10, 2013 Uncategorized

Norway bound

The OUGN user conference (on a cruise ship!) starts next week and I’m presenting there. From all reports, this is

Continue reading

March 29, 2013 Uncategorized

ORA_HASH and LOBs …. not nice partners

Consider the following simple setup SQL> create table t ( x int, b blob ); Table created. SQL> declare 2

Continue reading

March 29, 2013 Uncategorized

MERGE – concise syntax but not always fastest

A long time ago … a long long time ago (http://www.oracledba.co.uk/tips/merge_speed.htm) I wrote that MERGE works best over update and

Continue reading

March 4, 2013 Uncategorized

AUSOUG session February 2013

Thanks to everyone that came along. The slides can be found here

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

February 5, 2013 Uncategorized

Off to Norway !

In April I’m off to that famous conference that so many speak about with affection… The conference on a cruise

Continue reading

January 20, 2013 Uncategorized

EXCHANGE PARTITION those pesky columns

Here is my partitioned table SQL> desc PAR Name Null? Type —————————– ——– ———— X NUMBER(38) Y NUMBER(38) and it

Continue reading

Posts navigation

«Previous Posts 1 … 66 67 68 69 70 … 73 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"
    • How to TREAT data in a CLOB as JSON
    • Extended VARCHAR2 and the hidden LOB
    • How to generate random unique values
    • Modifying tables without losing materialized views
    • No more stale statistics in 19c
    • Free In-memory in Oracle Database 19c
    • Generating INSERT scripts that run fast!
    • 19c Express Edition #JoelKallmanDay
    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...