Below sql query can help us to identify if Oracle Database Vault is enabled or Disabled
SQL> SELECT * FROM V$OPTION WHERE PARAMETER = 'Oracle Database Vault';
PARAMETER VALUE CON_ID
-------------------------------------------------- -------- ----------
Oracle Database Vault FALSE 0
Database Vault is Disabled.