Re: Database Encryption
From: Stefan Koehler <contact_at_soocs.de>
Date: Thu, 7 Jun 2018 09:27:37 +0200 (CEST)
Message-ID: <1429941524.10124.1528356457560_at_ox.hosteurope.de>
Date: Thu, 7 Jun 2018 09:27:37 +0200 (CEST)
Message-ID: <1429941524.10124.1528356457560_at_ox.hosteurope.de>
Hello Arun,
two things came to my mind.
- CPU increase due to execution plan change You can have execution plan changes as you had to move (e.g. with dbms_redefinition) the data to encrypt it after enabling TDE and this can lead to a CPU increase.
- CPU type Your current used CPU type does not support hardware cryptographic acceleration or you are using TDE column encryption. For more details please check this white paper on page 3: http://www.oracle.com/technetwork/database/security/twp-transparent-data-encryption-bes-130696.pdf
P.S.: Despite all that there may be cases where TDE really has a performance impact (had some nice discussion about that at Hotsos last year).
Best Regards
Stefan Koehler
Independent Oracle performance consultant and researcher
Website: http://www.soocs.de
Twitter: _at_OracleSK
> Arun Chugh <arun.chugh1610_at_gmail.com> hat am 7. Juni 2018 um 05:51 geschrieben:
>
> 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-lReceived on Thu Jun 07 2018 - 09:27:37 CEST