I don't get to play with database encryption, so I speak entirely
theoretically.
Databases I get to work with all have extensive indexes (?indices?). All of
the indexes are supported by data files. If the data file supporting an
index is encrypted, does the index automatically get rebuilt? Are
statistics automatically regenerated?
Regards,
Gus
On Thu, Jun 7, 2018 at 3:29 AM Stefan Koehler <contact@xxxxxxxx> wrote:
Hello Arun,
two things came to my mind.
1) 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.
2) 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: @OracleSK
Arun Chugh <arun.chugh1610@xxxxxxxxx> hat am 7. Juni 2018 um 05:51geschrieben:
the performance of the database degraded to almost 40-50%
All,
We have encrypted almost all the datafiles of the database, post that
use in order to secure data with bit performance impact.
Could anyone suggest what is the other alternative method that we can
--
Regards,
Arun
//www.freelists.org/webpage/oracle-l