12c – Page 3 – Learning is not a spectator sport

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

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

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

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

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

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

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

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

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