RE: Database Encryption

From: Robert Freeman <>
Date: Mon, 11 Jun 2018 23:27:06 +0000
Message-ID: <>

What version of the database are we talking about here? Always helpful knowledge.

If it’s a supported version, I’d open an SR with Oracle, to be honest. You should not be seeing this kind of impact from encryption unless your server was already sitting on the edge. Depending on your version, there are known bugs (and – yes – bug fixes) for problems related to encryption and performance. Where are you seeing your biggest impacts? CPU, IO response times, changed execution plans? What was the command you used to do the encryption? Did you encrypt with or without salt? In other words, what have you done to quantify the problem you are seeing?

Stay the course and figure out this problem would be my suggestion. Don’t just jump ship because you’re taking on a little water.


Robert G. Freeman
Deliverer of Enterprise Data®
Cell: 801-703-3405

“Greater than the death of flesh is the death of hope. The death of dreams. Against this peril we can never surrender. The future is all around us, waiting in moments of transition, to be born in moments of revelation. No one knows the shape of that future, or where it will take us. We know only that it is always born in pain.”

From: [] On Behalf Of Arun Chugh Sent: Thursday, June 07, 2018 12:45 PM
Cc: Oracle Mailing List <> Subject: Re: Database Encryption

Yes right... Did not encrypt the system sysaux undo n temp..

On Thu, Jun 7, 2018, 22:53 <<>> wrote: You say “almost all the datafiles of the database”. I assume you mean tablespaces rather than datafiles but just wanted to confirm that you didn’t encrypt SYSTEM, SYSAUX, UNDO or TEMP?

Jay Miller
Sr. Oracle DBA

From:<> [<>] On Behalf Of Arun Chugh Sent: Wednesday, June 06, 2018 11:51 PM To: Oracle Mailing List
Subject: Database Encryption


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.


Received on Tue Jun 12 2018 - 01:27:06 CEST

Original text of this message