Re: 11g Tablespace Encryption

I wonder how that affects a database clone or restore to another location?

On 9/14/07, Ted Coyle <oracle-l_at_webthere.com> wrote:
>
> I attended a Tom Kyte Oracle presentation yesterday where he discussed 11g
> Tablespace encryption among other features. A question came up in one of
> the technical sessions concerning when the decryption took place and does
> any of the encrypted data ever wind up unencrypted in any of
> Undo/Redo/Temp
> control structures. The presenter didn't have an answer and Tom had
> zoomed
> out of there after the keynote so no chance to "Ask Tom Live" so to speak.
>
> Here's what I found in the 11g docs:
> "Transparent encryption/decryption takes place during disk input/output
> (I/O) and not for every logical access to the data. This leads to improved
> performance."
> -------
> "The encrypted data is protected during operations like JOIN and SORT.
> This
> means that the data is safe when it is moved to temporary tablespaces.
> Data
> in undo and redo logs is also protected."
>
> I'm interested in more info on this, so any links or comments are
> appreciated.
>
> Also, has anyone tested this feature for performance? Tom noted possible
> performance issues during the presentation.
>
> -Ted
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

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