• 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: 12c

November 22, 2016 Uncategorized

Attribute clustering (part 1)

One of the nice facilities in 12c is the ability to instruct the database to co-locate data during loading in

Continue reading

November 1, 2016 Uncategorized

Code enhancements without changing code

An interesting suggestion came through on AskTom this week, which prompted the following exploration. Let us assume you are populating

Continue reading

October 5, 2016 Uncategorized

Exadata Express – I’m in !

Jumping into 12.2 on Exadata Express is made easy with the packaging up of the client configuration files.  Here’s what

Continue reading

September 1, 2016 Uncategorized

Securefile in 12c – part 2

In a previous post, I noted that the parameter db_securefile changes from PERMITTED in 11g, to PREFERRED in 12c.  Jonathan

Continue reading

July 15, 2016 Uncategorized

Little enhancements are always nice

Before LATERAL and CROSS APPLY were added (exposed to us) in 12c, a common technique to do correlated joins was

Continue reading

July 4, 2016 Uncategorized

Direct mode operations on IOT’s

An AskTom contributor brought to my attention, that direct mode insert on index organized tables now appears possible in 12c. 

Continue reading

June 27, 2016 Uncategorized

dbms_output and the scheduler

One of the nifty things in 12c is the ability to pick up DBMS_OUTPUT output from your scheduler jobs. So

Continue reading

June 8, 2016 Uncategorized

12c FETCH PERCENT

A nice little feature in 12c is the FETCH FIRST n ROWS syntax, which is a simple shorthand to avoid

Continue reading

April 19, 2016 Uncategorized

Subtle variations in optimizer stats

Subtle variances in the way you work with statistics can have a significant impact on how your optimizer plans work

Continue reading

March 31, 2016 Uncategorized

Opatch quick tip

I was patching my 12.1.0.2 home installation to the latest patchset today, and got the following error: C:\oracle\stage\22581007>opatch apply Oracle

Continue reading

Posts navigation

«Previous Posts 1 2 3 4 5 6 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
    • Let's talk about Techiquette
    • Adding APEX 23.1 to your Database Free VM
    • How to do a GRANT on an entire schema
    • Why I blog
    • Implementing dynamic partitions AND subpartitions
    • Is "fragmentation" still a dirty word?
    • INITRANS grabs a little more space
    • How to generate random unique values
    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...