This is a run through of a performance investigation into Oracle tablespace encryption. These are the versions this test was performed on:
$ cat /etc/oracle-release Oracle Linux Server release 6.8 $ /u01/app/oracle/product/12.1.0.2/dbhome_1/OPatch/opatch lspatches 24315824;Database PSU 12.1.0.2.161018, Oracle JavaVM Component (OCT2016) 24006101;Database Patch Set Update : 12.1.0.2.161018 (24006101)
In this test I created an encrypted tablespace:
SQL> create tablespace is_encrypted datafile size 10m autoextend on next 10m encryption default storage(encrypt);
(this assumes you have setup a master encryption key already)
And I created an encrypted simple heap table with one row:
Recent comments
1 year 4 weeks ago
1 year 16 weeks ago
1 year 20 weeks ago
1 year 21 weeks ago
1 year 25 weeks ago
1 year 47 weeks ago
2 years 15 weeks ago
2 years 44 weeks ago
3 years 29 weeks ago
3 years 29 weeks ago