Logon/logoff In 19c EE Database Is More Than 10x Slower Than In 22.214.171.124
(Doc ID 2730374.1)
Last updated on DECEMBER 24, 2020
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
logins to the 19c database are much slower than in 11g.
The unix "time" command and a simple script that calls sqlplus 12 times, then exits. Result is the script takes > 10 times longer to execute in 19c, summarized below:
This is after disabling all logon / logoff triggers in 19c.
audit_trail = DB in both databases. Failed logins are logged in dba_audit_trail
Datbase has been upgraded to 19c
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document