• 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 13, 2015 Uncategorized

Inappropriate behaviour

You pick up little funny things in the day to day with Oracle. Like this one when you try to

Continue reading

January 13, 2015 Uncategorized

Data Pump import makes me crabby

I’m sitting here watching the import of a moderately sized database via transportable tablespaces. You know…the thing you use when

Continue reading

January 2, 2015 Uncategorized

Slow external table access

We had an interesting issue on 12.1.0.1, where users were reporting very slow performance on queries to external tables. When

Continue reading

January 1, 2015 Uncategorized

Analytics Demo Scripts

Video 2: Ranking rows https://livesql.oracle.com/apex/livesql/s/ch1tefsz0mc75pk4ix2jbfja7 Video 3: More options for ranking rows https://livesql.oracle.com/apex/livesql/s/clebs8f5n4kr2b3vjvnvvgxkn Video 4: Using the Tabibitosan method for

Continue reading

December 13, 2014 Uncategorized

ORA-4068 and CONSTANT keyword…good and bad

Anyone that has ever coded PLSQL will be familiar with the error ORA-4068, where you had some state persisted in

Continue reading

November 30, 2014 Uncategorized

truncated ddl in 12c (and 11.2.0.4)

Just curious if anyone else is seeing this behaviour.. SQL> set long 500000 SQL> @pt “select * from v$sql where

Continue reading

November 7, 2014 Uncategorized

AUSOUG conference Perth

The annual two day AUSOUG conference in Perth is well underway, and so far, its been a wonderfully successful event.

Continue reading

November 6, 2014 Uncategorized

A simple 12c query with a cool result …

Its not immediately obvious the significance of this query…but trust me…you’ll love it 🙂 SQL> select table_name, column_name from dba_tab_cols

Continue reading

October 5, 2014 Uncategorized

Openworld

Well, the annual spectacle of enormous proportions has come to a conclusion again. And thats probably the first reason I’d

Continue reading

October 1, 2014 Uncategorized

Slides from OakTableWorld and OpenWorld

Thanks to anyone that came along to my sessions at OpenWorld. You can review the slides via the links below:

Continue reading

Posts navigation

«Previous Posts 1 … 61 62 63 64 65 … 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...