Good news came from ODTUG this week about KScope20 in Boston, MA. Since it’s not the only conference I’m going to present in, I decided to write a short post
Using SPM to Control A Single SQL Execution PlanUsing SPM to Control A Single SQL Execution Plan
SQL Plan Management (SPM) is a powerful tool. It can do many things to control and evolve SQL execution plans to allow the most stable system. In this scenario I’ll
Debugging ORA-1775Debugging ORA-1775
ORA-1775 “looping chain of synonyms” can be found online quite easily. But every time they talk about a real loop of synonyms (like syn1 -> syn2 -> syn3 -> syn1)
Becoming a DBA Consultant SeriesBecoming a DBA Consultant Series
I’m really excited to finally go live with this. I’ve been working on this series for quite a while now and there’s a lot to write about. Being a consultant
Using DBCA in Silent Mode (19c)Using DBCA in Silent Mode (19c)
I have struggled a lot with DBCA in silent mode. Its documentation lacks quite a bit, the error messages are not great, and the tool has quite a few issues.
Promotion to ACE DirectorPromotion to ACE Director
If you follow on me on Twitter you probably know that by now. I have been recently promoted to Oracle ACE Director, the top level in the Oracle ACE Program.
Did You Know #32 – OEM Scripts LocationDid You Know #32 – OEM Scripts Location
Sometimes you get an alert from OEM but you can figure out why. It would help a lot if you could see the test and understand what exactly OEM is
Ansi Joins and ORA-25154Ansi Joins and ORA-25154
For one of my projects I needed to create all kind of dynamic queries and execute them against different tables. During this step I decided to use ansi joins even
Upgrading a GI on NFS to 18cUpgrading a GI on NFS to 18c
I wrote lately a couple of post about upgrading to 18c (why research is important and OCR and Voting disks on 18c and 19c). These posts were the result of
Archive Backups are not Deleted from Standby DatabaseArchive Backups are not Deleted from Standby Database
In an environment I’ve upgraded lately from 11.2 to 18c I found out that some backups are not getting deleted from the standby database. The environment has a single instance