Re: Database Encryption

Do you have statistics on your cpu usage and runqueue prior to encryption?

On Thu, Jun 7, 2018 at 11:36 AM, Arun Chugh <arun.chugh1610_at_gmail.com> wrote:

> 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_at_gmail.com> 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
>>
>>
>>

-- 
//
zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!
Visit us at zztat.net | _at_zztat_oracle | fb.me/zztat | zztat.net/blog/

--
http://www.freelists.org/webpage/oracle-l