TDE as a solution
Steve Palmer, April 06, 2017 - 8:31 am UTC
Why not use TDE - we were planning to.
Another application working at our patch level 11.2.0.3 recently went live with TDE and hit an issue that caused an outage.
The advice from within our Oracle TDE DBA's is to not go live at less than 11.2.0.4 or above. We cannot do that within our time constraints. So we are looking at something bespoke until we can get Oracle patched and TDE delivered.
April 07, 2017 - 2:20 am UTC
As a temporary solution, you could read the OS file and store the information in a context variable.
But of course, if you *really* want security keys floating around in a memory resident area...then...well.... you probably want to be very very careful with how you manage that :-)