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.
Amazing facts you have discussed in your article. thank you and update more informations
ReplyDeletePython Training in Chennai
Python Classes in Chennai
JAVA Training in Chennai
Hadoop Training in Chennai
Selenium Training in Chennai
Python Training in Chennai
Python Course in Chennai
This comment has been removed by the author.
ReplyDelete