Database Auditing

A dashboard in the examples focuses on BI usage tracking and database auditing. To use database auditing, you must ensure that this feature is enabled in the database. In particular, to see the SQL that is being executed, the database must be in extended auditing mode. You can check the status of your database by executing the following query:

SELECT name,value FROM v$parameter WHERE name LIKE 'audit%'

If your database is not in extended auditing mode (DB_EXTENDED), issue this command:

alter system set audit_trail='DB_EXTENDED' scope=spfile;

You must restart the database for this to take effect. These commands to enable auditing were not included in the example install scripts because they require a database restart. Finally, you must specify exactly what is going to be audited. See the section “Useful Scripts” later in this appendix to see how to do this.