In this post I’ll show what’s new in 20.2 Data Dictionary. To see comparison between other versions, check this post. Interesting additions are: Blockchain tables SQL macros Some details related
Category: Infrastructure
Oracle Data Dictionary ChangesOracle Data Dictionary Changes
As Oracle releases new versions, there is a lot of information about new major features, but sometimes small changes are unnoticed. I decided to check the differences in the Oracle
18.9 vs. 19.6 Data Dictionary Changes18.9 vs. 19.6 Data Dictionary Changes
In this post I’ll show what’s new in 19.6 Data Dictionary. To see comparison between other versions, check this post. Interesting additions are: Views/columns related to automatic indexing Some V$ALL
12.2.0.1 vs. 18.9 Data Dictionary Changes12.2.0.1 vs. 18.9 Data Dictionary Changes
In this post I’ll compare the Data Dictionary tables and columns between 12.2.0.1 and 18.9. To see comparison between other versions, check this post.
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.
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
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
All You Need to Know about Oracle Database PatchingAll You Need to Know about Oracle Database Patching
This is a topic I wrote about in the past (understanding Oracle patching and new version numbering). But now, after the new patching concept (since 12.2) and numbering change (since
OGB Appreciation Day – Standby DatabaseOGB Appreciation Day – Standby Database
It’s this time of the year again. If you don’t know what OTN/ODC/OGB appreciation day is (sorry, Oracle changed the branding over time, so the appreciation day title has changed