Enhancement to Increase Access Speed of V$ENCRYPTION_KEYS When Using OKV
(Doc ID 2484754.1)
Last updated on JANUARY 26, 2020
Applies to:Oracle Key Vault - Version 126.96.36.199 and later
Advanced Networking Option - Version 188.8.131.52 and later
Information in this document applies to any platform.
Accessing V$ENCRYPTION_KEYS takes about 5 mins with Oracle Key Vault. This is
extremely problematic when there are a lot of PDBs. We have tested with 256
PDBs and the system is unusable. This impacts the performance of instance
recovery, rotating TDE keys, and running SQL queries on the view.
Time required to rotate the TDE key of 1 PDB with 256 PDBs in a CDB: Elapsed: 00:04:52.79
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document