Slow Connection Using 12c Client When Network Encryption Is Enabled
(Doc ID 2247689.1)
Last updated on MAY 01, 2019
Applies to:
Advanced Networking Option - Version 12.1.0.2 and laterInformation in this document applies to any platform.
Symptoms
On a 12c database configured with Oracle Network Encryption the connection using a 12c client is five times slower than the connection with an 11g client. This can be easily seen in the sqlnet traces generated for both cases:
1) 12c client to 12c server
(3519893248) [<DATE> 06:09:02:326] nam_gnsp: Reading parameter
"SQLNET.CRYPTO_SEED" from parameter file
(3519893248) [<DATE> 06:09:02:326] nam_gnsp: Found value
"Fzuk56tJ0yeAGoz3jBJYbfwRwpDc7WJDbSC5OUEujxTDz7mInUloOwTbKccINL0NusJWce"
(3519893248) [<DATE> 06:09:02:401] nacomsd: entry <--- 75 msec delay.
.......
(3519893248) [<DATE> 06:09:02:401] nacomrp: exit
(3519893248) [<DATE> 06:09:02:493] naeccn: exit <---- 92 msec delay
"SQLNET.CRYPTO_SEED" from parameter file
(3519893248) [<DATE> 06:09:02:326] nam_gnsp: Found value
"Fzuk56tJ0yeAGoz3jBJYbfwRwpDc7WJDbSC5OUEujxTDz7mInUloOwTbKccINL0NusJWce"
(3519893248) [<DATE> 06:09:02:401] nacomsd: entry <--- 75 msec delay.
.......
(3519893248) [<DATE> 06:09:02:401] nacomrp: exit
(3519893248) [<DATE> 06:09:02:493] naeccn: exit <---- 92 msec delay
2) 11g client to 12c server
(1986175264) [<DATE> 06:10:56:903] nam_gnsp: Found value
"Fzuk56tJ0yeAGoz3jBJYbfwRwpDc7WJDbSC5OUEujxTDz7mInUloOwTbKccINL0NusJWce"
(1986175264) [<DATE> 06:10:56:906] nacomsd: entry <- 3 msec delay
(1986175264) [<DATE> 06:10:56:906] nacomrp: exit
(1986175264) [<DATE> 06:10:56:908] naeccn: exit <---- 2 msec delay
"Fzuk56tJ0yeAGoz3jBJYbfwRwpDc7WJDbSC5OUEujxTDz7mInUloOwTbKccINL0NusJWce"
(1986175264) [<DATE> 06:10:56:906] nacomsd: entry <- 3 msec delay
(1986175264) [<DATE> 06:10:56:906] nacomrp: exit
(1986175264) [<DATE> 06:10:56:908] naeccn: exit <---- 2 msec delay
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |