Re: Oracle 10g R2 and TDE - change in space used?

Jonathan Leffler wrote:
> Does each row (field?) grow, or is the extra key-related data stored somewhere else?

Yes. Each column is stored encrypted in place. AFAIK

> For unsalted columns, it
> is conceivable that there is no growth; I fail to see how you can add
> salt to the encryption and not increase the storage a bit (enough for
> the salt, at least).

IIRC even unsalted columns can be much larger, e.g. a number from few bytes goes to 30 bytes. A salted column is, of course, larger.

> Any pointers to where to look for the information would be gratefully
> received.

Some month ago, to have an idea on how it works, I dumped some blocks... I suggest you to do the same...

HTH
Chris Received on Tue Dec 06 2005 - 15:46:43 CST