This is not my tip, but Connor Mcdonald‘s. I attended a couple of his sessions at Open World 18 and had to write about this small but really useful feature
Category: Features
Oracle 19c – Features We Know AboutOracle 19c – Features We Know About
Oracle Open World was interesting like every year. This year, Oracle started talking about features that will probably be in Oracle 19c (which is the last 12.2 release). The rumor
Getting Crazy with Analytic Functions and Group ByGetting Crazy with Analytic Functions and Group By
This topic has been sitting in my backlog for a long time and I finally decided to write it. Analytic functions are not so new anymore (they’ve been around since
When Even Histograms Can't HelpWhen Even Histograms Can't Help
Here is an interesting optimizer case where updated statistics and histograms cannot solve the performance problem. This might be an uncommon case, but it happened for one of my clients
ODC Appreciation Day – Image-Based InstallationODC Appreciation Day – Image-Based Installation
As every year since 2016, we’re having the ODC Appreciation Day around October. If you don’t know what “ODC Appreciation Day” is, it is Tim Hall’s initiative to simply say
Using DBCA in Silent ModeUsing DBCA in Silent Mode
One of my customers is a software company and they use Oracle database for their product. One of the things we need to do when they certify an Oracle version
Bug When Patching ProductionBug When Patching Production
I had a bad night last Thursday.After patching two test RAC databases and one production RAC with 180417 DB Bundle Patch (and some one-offs), I got to the point where
One-off Patch FrustrationOne-off Patch Frustration
Lately I started patching a client’s database (12.1.0.2) to the latest PSU (180417). This is a RAC environment with streams and all kind of other features, so over the time
Datapach issuesDatapach issues
This week I worked on a messy patch. I have a RAC environment with 12.1.0.2 and an old PSU and all kind of one-off patches and I wanted to install
Did You Know #26 – Restoring Standby Control FileDid You Know #26 – Restoring Standby Control File
If you read my post Restoring Standby Database, you know that one of the problems I had was that the new control file refused to open the database with resetlogs