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

February 21, 2023 Uncategorized

A key difference between TP and TPURGENT

When you are using Autonomous Transaction Processing database, as well as the LOW, MEDIUM and HIGH services that are also

Continue reading

November 9, 2022 Uncategorized

From stateful to stateless PL/SQL

I’ve done a lot of talks mainly around the tremendous performance benefits you can get just by employing a little

Continue reading

October 11, 2022 Uncategorized

Easy data access from Excel #JoelKallmanDay

I suspect Joel would have kittens if he knew I would use the appreciation day to talk about Excel instead

Continue reading

July 14, 2022 Uncategorized

Juice up your JSON on Autonomous

As many readers will be aware, we introduced a cool new JSON datatype in 21c which offers more features and

Continue reading

February 2, 2022 Uncategorized

Awesome DATE / TIMESTAMP enhancement in Autonomous Database

Date management is a commonly encountered issue when customers want to move their database to a cloud environment. If you

Continue reading

September 15, 2021 Uncategorized

SQL trace on your cloud database

There are so many great performance monitoring tools that have come along in the Oracle Database since 10g – things

Continue reading

April 22, 2021 Uncategorized

Much ado about (paying) nothing

A couple of days ago, we announced some more free goodies to Oracle Cloud. As most readers will know, we

Continue reading

stack of macro vitamins
September 14, 2020 Uncategorized

When can I use SQL Macros?

One of the very cool features we’ve been talking about for 20c is SQL Macros. But you no longer need

Continue reading

woman working on flexibility
August 31, 2020 Uncategorized

How to control resource usage on Autonomous

When you connect to your Autonomous Database, you get to choose from some predefined services. The services available depends on

Continue reading

July 15, 2020 Uncategorized

Upgrading…Its Time!

Gough Whitlam was an Australian politician who rose to power in the 1970s with the campaign slogan “It’s Time!”. Politics

Continue reading

Posts navigation

1 2 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
    • Connection shortcuts with a wallet
    • How to generate random unique values
    • Generating INSERT scripts that run fast!
    • No more stale statistics in 19c
    • Free In-memory in Oracle Database 19c
    • Updating indexes with partition maintenance
    • Automatically generate audit capture for tables
    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...