There was a problem occurs after upgrading to 12.1.0.2.
he following statement performs poorly (taking 2+ seconds to complete) and consumes CPU:
update user$ set spare6=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-00-00', to_date(NULL), :2) where user#=:1
The behavior is seen specifically when Transparent Data Encryption (TDE) and FIPS mode are both in use.
This was analyzed in Bug 25839004 - SLOW LOGIN UPDATE USER$ QUERY WHEN TDE AND DBFIPS_140 ENABLED, and found to be a duplicate of an unpublished Bug.
Solution : Apply Patch 25635149.
he following statement performs poorly (taking 2+ seconds to complete) and consumes CPU:
update user$ set spare6=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-00-00', to_date(NULL), :2) where user#=:1
The behavior is seen specifically when Transparent Data Encryption (TDE) and FIPS mode are both in use.
This was analyzed in Bug 25839004 - SLOW LOGIN UPDATE USER$ QUERY WHEN TDE AND DBFIPS_140 ENABLED, and found to be a duplicate of an unpublished Bug.
Solution : Apply Patch 25635149.
