3des168

Connection encryption is killing my performance! Help!

Submitted by dave on Mon, 10/22/2018 - 23:11

I find Encryption is blamed for a lot of performance issues so wanted to find out for myself how much of a performance hit we might be taking for common operations. There ain't no free lunch. Adding any extra processing or manipulation to an operation is going to add time to that operation.

Tags: 
ASO
TDE
encryption
aes256
3des168

Algorithm preference in SQLNET.ENCRYPTION_TYPES_SERVER

Submitted by dave on Thu, 10/04/2018 - 17:24

If you have clients connecting to a server and the clients don't specify a specific encryption algorithm in SQLNET.ENCRYPTION_TYPES_CLIENT, be aware that the order of the algorithms listed in SQLNET.ORA on the server side matters...

If you don't specify SQLNET.ENCRYPTION_TYPES_CLIENT from a 12.2 client configuration, a SQLNet client side trace shows the following possibilities, the choices are listed from most secure to least secure:

Tags: 
oracle
encryption
aes256
3des168
Subscribe to 3des168