V$ENCRYPTION_WALLET

V$ENCRYPTION_WALLET displays information on the status of the wallet and the wallet location for Transparent Data Encryption.


Column Datatype Description

WRL_TYPE

VARCHAR2(20)

Type of the wallet resource locator (for example, FILE)

WRL_PARAMETER

VARCHAR2(4000)

Parameter of the wallet resource locator (for example, absolute file name if WRL_TYPE = FILE)

STATUS

VARCHAR2(30)

Status of the wallet:

  • CLOSED

  • NOT_AVAILABLE

  • OPEN

  • OPEN_NO_MASTER_KEY

  • OPEN_UNKNOWN_MASTER_KEY_STATUS

WALLET_TYPE

VARCHAR2(20)

Displays the type of keystore being used, HSM or SOFTWARE_KEYSTORE.

If the keystore was created with the mkstore utility, then the WALLET_TYPE is UNKNOWN.

WALLET_ORDER

VARCHAR2(9)

If only a single wallet is configured, the value in this column is SINGLE.

When more than one wallet is configured, the value in this column shows whether the wallet is primary (holds the current master key) or secondary (holds old keys). The lookup of the master key will happen in the primary keystore first, and then in the secondary keystore, if required.

Possible values:

  • PRIMARY

  • SECONDARY

If there is only one type of keystore (Hardware Security Module or Software Keystore) being used, then PRIMARY will appear.

If both types are used, then the value in this column shows the order in which each keystore will be looked up.

FULLY_BACKED_UP

VARCHAR2(9)

Indicates whether all the keys in the keystore have been backed up

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data