Apps DBA Diaries

This blog offers expert insights on Oracle E-Business Suite (EBS), Database Administration, and Oracle Cloud Infrastructure (OCI). Explore in-depth tutorials, best practices, and solutions for Oracle EBS management, Oracle Database performance tuning, and OCI cloud administration. Whether you're optimizing Oracle databases, migrating to the cloud, or managing enterprise applications, our blog provides the latest tips and strategies to enhance your Oracle environment and ensure peak performance.

Thursday, 4 June 2020

How to check if Oracle Database Vault is enabled?

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.

Apps DBA Diaries

Pages

Thursday, 4 June 2020

How to check if Oracle Database Vault is enabled?

No comments:

Post a Comment