SQL Query to Check Database Vault is enable or not.
SQL> SELECT * FROM V$OPTION WHERE PARAMETER = 'Oracle
Database Vault';
PARAMETER VALUE
CON_ID
---------------------- ------------------------ ----------
Oracle Database Vault
TRUE 0
Disabling Steps: