• 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!
January 18, 2014 Uncategorized

ORA-65131 grrrr

So…the future is container databases ? Cool ! I’ll create all my databases as container databases….I’m so happy….until SQL> CREATE

Continue reading

January 18, 2014 Uncategorized

Man…I really really like this :-)

Yeah yeah, you can argue with me about backward compatibility, but I’m so glad someone snuck this into 12c… 11.2

Continue reading

December 20, 2013 Uncategorized

The challenge of optimization

With every release of Oracle, more and more power comes to the optimizer. Many of these are new features (such

Continue reading

December 7, 2013 Uncategorized

Cloning databases

My friend Kyle wrote a blog piece a while back http://www.kylehailey.com/what-delphix-does-in-1-minute-22-seconds/ Now, not to criticise Delphix (in fact,the opposite –

Continue reading

December 7, 2013 Uncategorized

number of set bits

declare n number := ….; tmp number; begin tmp := n – ( bitand ((n / 2) ,3681400539)) – (bitand

Continue reading

November 30, 2013 Uncategorized

The cost of Oracle

It’s not uncommon for people on one hand to expound the functionality, performance and features of Oracle, whilst on the

Continue reading

November 24, 2013 Uncategorized

Once you’ve done your I/O…there’s still more to do !

The world is obsessed with I/O nowadays…. This is understandable – we’re in the middle of a pioneering period for

Continue reading

October 20, 2013 Uncategorized

A good day…

I work for a company that provides betting to consumers in Australia… In Australia, the three biggest days for betting

Continue reading

October 3, 2013 Uncategorized

Openworld slides

Can be viewed here http://www.slideshare.net/hamcdc/sep13-optimizer-stats http://www.slideshare.net/hamcdc/sep13-sql-tuning-101 http://www.slideshare.net/hamcdc/sep13-analytics

September 30, 2013 Uncategorized

Thoughts from OpenWorld

The amazing coordination of so many things: – feeding 60,000 delegates goes off without a hitch.  The food is not

Continue reading

Posts navigation

«Previous Posts 1 … 64 65 66 67 68 … 74 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

    • Bringing Multimedia back into 19c!
    • How do I stop the use of TRUNCATE
    • Adding APEX 23.1 to your Database Free VM
    • How to do a GRANT on an entire schema
    • Is "fragmentation" still a dirty word?
    • Implementing dynamic partitions AND subpartitions
    • No more stale statistics in 19c
    • DBMS_JOB and 19c - code changes needed
    • When can I use SQL Macros?
    • Some "must-have" ideas for your next meetup
    Blog at WordPress.com.
    • Follow Following
      • Learning is not a spectator sport
      • Join 863 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...