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).
Now, ORAdiff (https://oradiff.oracle.com/) has implemented a way to simply check all the historical changes on default values of Oracle Database regular and underscore parameters. This can be accessed on the menu option: Parameters -> Search Parameters (and enable the "Show Default Value" radio button).
For example: If you also enable the "Show Underscores" option, and start typing "tablespace_encryption_default_algorithm", you will notice that there are 2 parameters:
- _tablespace_encryption_default_algorithm (19c or lower release)
- tablespace_encryption_default_algorithm (21c or higher release)
Also note that the default value of this parameter changed starting in 23c to AES256.
Check the short 2-minute video below to get this quick tip:
Try it out and let me know your input!
Have you enjoyed? Please leave a comment or give a 👍!
