8.201 V$ENCRYPTION_KEYS
V$ENCRYPTION_KEYS
displays master key description attributes.
Note that, even if Transparent Data Encryption (TDE) is not configured in the database, a query of V$ENCRYPTION_KEYS
checks for TDE configuration validity and may print warnings in alert log.
Column | Datatype | Description |
---|---|---|
|
|
Master key identifier |
|
|
Master key identifier, in hex format |
|
|
Associated user-defined Information with the master key |
|
|
Time that the master key was created |
|
|
Time that the master key was put into use |
|
|
User that created the master key |
|
|
User ID that created the master key |
|
|
User that activated the master key |
|
|
User ID that activated the master key |
|
|
Indicates whether the master key is used for TDE operations in a PDB or not |
|
|
Type of keystore in which the master key is stored:
|
|
|
Provides information about the origin of the master key:
|
|
|
Indicates whether the key has been backed up or not |
|
|
Database that created the key |
|
|
Database ID where the key was created |
|
|
Instance name of the instance where the key was created |
|
|
Instance number of the instance where the key was created |
|
|
Serial number of the instance where the key was created |
|
|
PDB where the key was created |
|
|
PDB ID where the key was created |
|
|
PDB UID where the key was created |
|
|
PDB GUID where the key was created |
|
|
Database that activated the key |
|
|
Database ID where the key was activated |
|
|
Instance name of the instance where the key was activated |
|
|
Instance number of the instance where the key was activated |
|
|
Serial number of the instance where the key was activated |
|
|
PDB where the key was activated |
|
|
PDB ID where the key was activated |
|
|
PDB UID where the key was activated |
|
|
PDB GUID where the key was activated |
|
|
Master key encryption algorithm |
|
|
The ID of the container to which the data pertains. Possible values include:
|
See Also:
Oracle Database Advanced Security Guide for information about keystore management