• 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!

Category: Uncategorized

a non-descript blob of red paint
April 6, 2022 Uncategorized

DBMS_METADATA for INDEXES

Just a quick tip on using DBMS_METADATA that caught me out the other day. If you have a table and

Continue reading

a female police officer standing guard
March 30, 2022 Uncategorized

Enforcing DEFAULT values

Handling default values on columns has been an age old problem that we solved in 12c with extensions to the

Continue reading

a cassette tape with the tape unravelling out of it
March 28, 2022 Uncategorized

Block recovery a lot easier than I thought

I tweeted this snippet the other day because to be honest I was just overjoyed about being able to get

Continue reading

two hands shuffling a deck of cards in close up
March 22, 2022 Uncategorized

When re-ordering columns is warranted

Nearly 10 years ago(!!!) I blogged about how you can toggle columns to invisible and back again as a means

Continue reading

a truck overfilled with cut logs driving on the highway
March 10, 2022 Uncategorized

Don’t run tight on PGA

The database on my laptop seemed slow this morning. Normally I would put this down to the fact that I’ve

Continue reading

two identical sheep
March 7, 2022 Uncategorized

After you clone your pluggable database

Recently I cloned one my (pluggable) databases to a throwaway copy so that I could do some testing of an

Continue reading

soapy hands washing under a running tap
March 2, 2022 Uncategorized

Cleaner DDL than DBMS_METADATA

Most of us with any kind of longevity in the Oracle world will remember the days when we wrote our

Continue reading

a close up of a sleeping dog with its tongue hanging out
February 16, 2022 Uncategorized

INITRANS grabs a little more space

INITRANS defines how many concurrent transactions you can have within a single datablock for a segment (table, materialized view, etc).

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

February 6, 2022 Uncategorized

A new dictionary view for privileges

So I tweeted this out on Friday and this reflects one of my joys with working with Oracle technology. The

Continue reading

Posts navigation

«Previous Posts 1 2 3 4 … 70 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.

Top Posts & Pages

  • How to do a GRANT on an entire schema
  • Why you keep getting "ORA-01653: unable to extend table"
  • Extending in-lists past the 1000 item barrier
  • Connection shortcuts with a wallet
  • No more stale statistics in 19c
  • How to TREAT data in a CLOB as JSON
  • Automatically generate audit capture for tables
  • Comparing two database objects for differences
  • Generating INSERT scripts that run fast!
  • Free In-memory in Oracle Database 19c
Blog at WordPress.com.
Learning is not a spectator sport
Blog at WordPress.com.
  • Follow Following
    • Learning is not a spectator sport
    • Join 814 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...