Higher CPU usage on the e-Business Suite database after implementing advanced user encryption

(Doc ID 2349156.1)

Last updated on JANUARY 25, 2018

Applies to:

Oracle E-Business Suite Performance - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

Overall CPU usage on the e-Business Suite database is increased.

Also following SQL is taking time during login :

 

Changes

Non-reversible hash password algorithm has been implemented using following :

      R12: New Feature: Enhance Security With Non-Reversible Hash Password FNDCPASS <>

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms