Re: Database Encryption

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 7 Jun 2018 10:43:51 +0000
Message-ID: <MM1P123MB0842D1A5DEE84E03E7EDF21CA5640_at_MM1P123MB0842.GBRP123.PROD.OUTLOOK.COM>

Quick and dirty check which may confirm it's purely the CPU impact of TDE.

AWR (or statspack) reports for matching time periods / batch runs with and without TDE

a) Is there little change at the report level in buffer gets, and pl/sql CPU time but a significant increase in CPU time. (check osstats, time model, as well as Top 10 for this)
b) Does the content of the Top SQL by CPU stay pretty much the same (SQL and execution count) with increased CPU (per execution)
c) Track the Top SQL by CPU to the TOP SQL by buffer gets, and Top SQL by physical reads are the gets/reads (per execution) consistent.
d) For "same SQL, significantly different costs per execution" check execution plans. (awrsqrpt.sql or equivalent).

Regards
Jonathan Lewis

---

From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Arun Chugh <arun.chugh1610_at_gmail.com> Sent: 07 June 2018 05:36
To: tim.evdbt_at_gmail.com
Cc: Oracle Mailing List
Subject: 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_at_gmail.com<mailto: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

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

Received on Thu Jun 07 2018 - 12:43:51 CEST