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

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

February 11, 2022 Uncategorized

V$SESSION_LONGOPS and parallel query

For pretty much as long as I can remember, the view V$SESSION_LONGOPS has existed. It has a suite of columns

Continue reading

June 4, 2021 Uncategorized

Parallel DML and locking – going manual

Generally speaking, if you have a giant chunk of data over “here”, and you need to load it into a

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

August 7, 2019 Uncategorized

Autonomous Transaction Processing – your slice of the pie

I grabbed the following screen shot from a slide deck I’ve been giving about Autonomous Transaction Processing (ATP). It shows

Continue reading

January 21, 2016 Uncategorized

Session level parallelism

If you’ve got a stack of large I/O operations to perform, you might want to take advantage of the all

Continue reading

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 I blog
    • Why you keep getting "ORA-01653: unable to extend table"
    • Adding APEX 23.1 to your Database Free VM
    • No more stale statistics in 19c
    • How to TREAT data in a CLOB as JSON
    • Implementing dynamic partitions AND subpartitions
    • INITRANS grabs a little more space
    • Bringing Multimedia back into 19c!
    • Connection shortcuts with a wallet
    Blog at WordPress.com.
    • Follow Following
      • Learning is not a spectator sport
      • Join 864 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