My Oracle Support Banner

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 12.2.0.0 and later
Advanced Networking Option - Version 11.2.0.4 and later
Information in this document applies to any platform.

Goal

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

Solution

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
Goal
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.