I usually don’t work with the local version of EM. I haven’t used DB Console in 11g and below so much, and I used EM Express in 12c even less.
Did You Know #28 – Standby + RACDid You Know #28 – Standby + RAC
In an Oracle Data Guard configuration, the primary and standby databases can have different configurations. It’s very common to have a smaller server for the standby database (less CPUs, less
Did You Know #27 – SQL*Plus ErrorloggingDid You Know #27 – SQL*Plus Errorlogging
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
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
Open World 2019 DatesOpen World 2019 Dates
In the past, during OOW Oracle published the official dates of OOW of the following year, but in the last few years they stopped doing this, so we can’t be
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
If ORA- Codes Were BuildingsIf ORA- Codes Were Buildings
It all started when Franck Pachot tweeted a simple tweet. The tweet was of building number 600 at Oracle offices and Franck wrote: “Dedicated to all ORA-600 friends”. To that
Bye Bye Oracle Open World 2018Bye Bye Oracle Open World 2018
Oracle Open World 2018 has come to an end. This was my 9th OOW (I’ve been attending OOW since 2010) and my second as a speaker, and it was awesome.
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
DST Patch in Active Standby EnvironmentDST Patch in Active Standby Environment
Different software components (operating systems, databases, etc.) are updating our clocks automatically when our country changes the clock (when daylight saving starts or ends). In order to do that, the