Verifying Fine-Grained Auditing Configuration in Oracle DB

  

#Query to check if Fine-grained Auditing is configured or not in Oracle database. SQL> set lines 300 pages 3000 SQL> col parameter for a25 SQL> col value for a12 SQL> SELECT PARAMETER, VALUE FROM V$OPTION WHERE PARAMETER='Fine-grained Auditing'; PARAMETER                 VALUE ------------------------- ------------ Fine-grained Auditing     TRUE