Slow Connection Using 12c Client When Network Encryption Is Enabled (Doc ID 2247689.1)

Last updated on MARCH 24, 2017

Applies to:

Advanced Networking Option - Version 12.1.0.2 and later
Information 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) [03-APR-2015 06:09:02:326] nam_gnsp: Reading parameter
 "SQLNET.CRYPTO_SEED" from parameter file
 (3519893248) [03-APR-2015 06:09:02:326] nam_gnsp: Found value
 "Fzuk56tJ0yeAGoz3jBJYbfwRwpDc7WJDbSC5OUEujxTDz7mInUloOwTbKccINL0NusJWce"
 (3519893248) [03-APR-2015 06:09:02:401] nacomsd: entry <--- 75 msec delay.
 .......
 (3519893248) [03-APR-2015 06:09:02:401] nacomrp: exit
 (3519893248) [03-APR-2015 06:09:02:493] naeccn: exit <---- 92 msec delay

 

 2) 11g client to 12c server


 

(1986175264) [03-APR-2015 06:10:56:903] nam_gnsp: Found value
 "Fzuk56tJ0yeAGoz3jBJYbfwRwpDc7WJDbSC5OUEujxTDz7mInUloOwTbKccINL0NusJWce"
 (1986175264) [03-APR-2015 06:10:56:906] nacomsd: entry <- 3 msec delay
 (1986175264) [03-APR-2015 06:10:56:906] nacomrp: exit
 (1986175264) [03-APR-2015 06:10:56:908] naeccn: exit <---- 2 msec delay

 

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