Also are you using an HSM to store the encryption key or local wallet? Just
curious whether you might be having latency issues with an external key store.
________________________________
From: Arun Chugh <arun.chugh1610@xxxxxxxxx>
Date: June 6, 2018 at 11:38:05 PM CDT
To: tim.evdbt@xxxxxxxxx <tim.evdbt@xxxxxxxxx>
Cc: Oracle Mailing List <oracle-l@xxxxxxxxxxxxx>
Subject: [External] Re: Database Encryption
We are using TDE for encryption and also getting the wait event "CPU+wait for
CPU" ... As an evidence we decrypt the database and it behaviour back to normal
as it was prior to encryption.
On Thu, Jun 7, 2018, 09:31 Tim Gorman
<tim.evdbt@xxxxxxxxx<mailto:tim.evdbt@xxxxxxxxx>> wrote:
What evidence do you have that TDE has affected performance 40-50%?
Can you prove that there has not been a change in execution plans?
On 6/6/18 21:51, Arun Chugh wrote:
All,
We have encrypted almost all the datafiles of the database, post that the
performance of the database degraded to almost 40-50%
Could anyone suggest what is the other alternative method that we can use in
order to secure data with bit performance impact.
Regards,
Arun
--
//www.freelists.org/webpage/oracle-l