How to get all historical changes on default values of Oracle Database parameters

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). …

Continue reading

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 …

Continue reading

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 …

Continue reading

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 …

Continue reading

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 …

Continue reading