A performance deep dive into tablespace encryption

Frits Hoogland Weblog

This is a run through of a performance investigation into Oracle tablespace encryption. These are the versions this test was performed on:

In this test I created an encrypted tablespace:

(this assumes you have setup a master encryption key already)
And I created an encrypted simple heap table with one row:

Also, in order to do some performance tests, I created a simple heap table with a lot of rows:

Let me first go back to basics a little and explain how tablespace encryption works: tablespace encryption sets the ‘E’ flag in the cache header of blocks of a segment which contain data (block type# 6, ‘trans data’), which means the block will be UNencrypted in the buffercache, but will be encrypted once the block is persisted to disk. If a block is read from disk into the cache, it means it must be decrypted first. Once a block is…

View original post 2,991 more words