Hello, I have a few local .net webapps that query ms access database for data. That ms access file has some odbc linked table to oracle 12. I am trying to switch these data connections from unencrypted to encrypted so I was given settings to plug into sqlnet.ora file in the oracle install folder. When encryption is disabled, my queries take about 2 seconds to complete. When I turn on encryption, it takes 25 seconds to complete. 25 seconds wont work for my shop so I am trying to figure out how to improve that. I also tried oledb connection and it has the same issue. However, oledb must cache that connection because once I run the oledb first oledb query that takes 25 seconds, if i were to run it again shortly after then it only takes 2 seconds. I am using an oracle 10 32bit driver, but have also test with an oracle 12 64 driver. This doesn't seem to be .net related because i experience this same slowness caused by encryption in the odbc windows application if I do a test connection. Any thoughts how I can improve the connection time?
Here is the settings of my sqlnet.ora file
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES, EZCONNECT)
SQLNET.ENCRYPTION_CLIENT=REQUESTED
SQLNET.CRYPTO_CHECKSUM_SERVER=REQUESTED
SQLNET.ENCRYPTION_TYPES_SERVER = (AES256,RC4_256,AES192,3DES168,AES128,RC4_128,3DES112,RC4_56,DES,RC4_40,DES40)