Search results

UPDATE To USER$.SPARE6 Performs Poorly (2-Second Execution Time) and Consumes CPU

There was a  problem occurs after upgrading to

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.