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 Data Dictionary between different versions. Sometimes Oracle add important things there, and sometimes these changes reflect a bigger change that was made to the database system.
I’ll try to start a series here about these changes, just showing what’s different and you can scan the list to see if you can spot something interesting.
Currently there is only one post here, but I’ll keep updating it:
12.2.0.1 vs. 18.9 Data Dictionary changes
Hi Liron,
Nice idea 🙂
What is less nice, however, is that some of the new dictionary views are still NOT documented in the Database Reference, even in a later version.
For example, the following 3 still DO NOT appear in the Database Reference for version 20c,
though, as by your comparison, they were added in version 19.6 :
DBA_JSON_COLSTORAGE_STATS
DBA_JSON_TABLE_COLS_COUNT
DBA_JSON_VIEW_COLS_COUNT
And, probably, there are many others missing …
Cheers & Best Regards,
Iudith
Thanks Iudith,
Yes, there is a lot of stuff that is still undocumented. I wanted to make this list to put all of these changes in a single place. From here, people can review the changes and can investigate the ones they find interesting.
Hope this will help and if I have any news or updates, I’ll post it as well.
Liron