GotoDBA Features,Infrastructure Oracle Data Dictionary Changes

Oracle 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 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

18.9 vs. 19.6 Data Dictionary changes

19.6 vs. 20.2 Data Dictionary changes

4 thoughts on “Oracle Data Dictionary Changes”

  1. 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

    1. 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

Leave a Reply

Your email address will not be published. Required fields are marked *

Related Post