Re: TDE and execution plans

From: Job Miller <jobmiller_at_yahoo.com>
Date: Tue, 11 Mar 2014 11:01:43 -0700 (PDT)
Message-ID: <1394560903.12702.YahooMailNeo_at_web141004.mail.bf1.yahoo.com>

The docs hypothesize the overhead of tablespace encryption and mention it includes redo encryption as well.

http://docs.oracle.com/cd/E11882_01/network.112/e10746/asotrans.htm#ASOAG600

7.1.2.2 TDE Tablespace Encryption

TDE tablespace encryption enables you to encrypt an entire tablespace. All objects created in the encrypted tablespace are automatically encrypted. TDE tablespace encryption is useful if you want to secure sensitive data in tables. You do not need to perform a granular analysis of each table column to determine the columns that need encryption.

In addition, TDE tablespace encryption takes advantage of bulk encryption and caching to provide enhanced performance. While the actual performance impact on applications can vary, the performance overhead is roughly estimated to be in between 5% and 8%.

TDE tablespace encryption is a good alternative to TDE column encryption if your tables contain sensitive data in multiple columns, or if you want to protect the entire table and not just individual columns.

TDE tablespace encryption encrypts all data that is stored in an encrypted tablespace and its corresponding redo data.

....

---

 From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk> To: "Hameed, Amir" <Amir.Hameed_at_xerox.com>; "oracle-l_at_freelists.org" <oracle-l_at_freelists.org> Sent: Tuesday, March 11, 2014 12:06 PM
Subject: RE: TDE and execution plans

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

Received on Tue Mar 11 2014 - 19:01:43 CET