Whenever we patch, upgrade, or migrate our database server, it is important to track what changes we have between the source/target release or patch level to track any possible regressions. One of the things I've been struggling with for years is how to track all the changes that happen to database parameters (including the underscores). …
Dec 05
How to check the code of the most important Oracle internal objects without having a database
Sometimes, I have to debug and troubleshoot something, and I see myself in a position where I need to get the dictionary code of internal Oracle objects, and the most common way to do that is using DBMS_METADATA. Let's say, for example, that I need to get the view SQL code for DBA_USERS we had …
Nov 22
How get the contents of the most important Oracle internal views without having a database
In my daily work, sometimes I see myself in a position that I need to get the vision of an Oracle dictionary table for a specific release. Let's say, for example, that I need to get the list of all parameters we had back in 12.1.0.2 with July 2021 patch applied. Or maybe, what if …
Oct 18
What is new in Oracle Database 19.21 RU
Oracle Database 19.21 RU was just released! As soon as it is available in My Oracle Support to download, we also add it to ORAdiff app: https://oradiff.oracle.com/ So, what is new? You can check yourself by accessing ORAdiff website and comparing each section, but below I will give a summary of the main changes that …
Aug 17
LAOUC 2023 Slides
After 2 intensive weeks, the LAOUC Tour 2023 is over! It was the first tour after the 2019 pandemic and it was great to see all that legion of people interested in Oracle technologies. Over the 7 countries that I've visited during the tour, I gave the 4 sessions above: Secret Features of Oracle Data …