Re: Database Encryption

From: Arun Chugh <arun.chugh1610_at_gmail.com>
Date: Thu, 7 Jun 2018 10:38:21 +0530
Message-ID: <CAOyn3GcShqp9X6_u5MgTP_Dt+tctFBNsSWum6j3nGqS5Rfo3Xw_at_mail.gmail.com>



Yes we have the CPU statistics with us.

Regards,
Arun

On Thu, Jun 7, 2018, 10:36 Stefan Knecht <knecht.stefan_at_gmail.com> wrote:

> 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
Received on Thu Jun 07 2018 - 07:08:21 CEST

Original text of this message