Hi,
Today I stumbled upon a quirk – the PASSWORD_ROLLOVER_TIME resource limit value was shown as 3600 instead of 0.0416 on one of the PDBs. I have no explanation for it, but it might be related to its historical version changes. Originally, the CDB was created in RU 19.8, and after gradually applying patches, it's currently on RU 19.24.
I had heard before that this behavior might have been the case after applying RU 19.12, and the solution was to recreate the DBA_PROFILES view. I reapplied the script $ORACLE_HOME/rdbms/admin/cdenv.sql (which contains the SQL for it) on the CDB and at every PDB level, and actually it helped. As a result, the PASSWORD_ROLLOVER_TIME is now displayed as a fraction of a day, as it is in every other database, whether it's a CDB or non-CDB.
