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
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
Jumping into 12.2 on Exadata Express is made easy with the packaging up of the client configuration files. Here’s what
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