Step 1: Log In and Enable Standard Auditing

First, log in, and, if necessary, enable standard auditing.

To enable standard auditing:  

1. Start Database Control.

2. Log in as SYS.

   • User Name: SYS

   • Password: Enter your password.

   • Connect As: SYSDBA

3. Click Server to display the Server subpage.

4. In the Database Configuration section, click Initialization Parameters.

   The Initialization Parameters page appears.

5. Click SPFile to display the SPFile subpage.

   If the SPFile tab does not display in your installation, then you did not install Oracle Database using a server parameters file. Go to the next step.

6. In the Name field, enter AUDIT_TRAIL to find the AUDIT_TRAIL parameter, and then click Go.

   You can enter the first few characters of the parameter, for example, AUDIT. Alternatively, you can scroll down the list of parameters to find the AUDIT_TRAIL parameter. To sort the list of parameters in alphabetical order, click the Name column.

7. In the Value field, make a note of the current setting, and then change it to DB_EXTENDED.

   By default, the AUDIT_TRAIL parameter is set to DB, which enables database auditing and directs all audit records to the database audit trail (SYS.AUD$), except for records that are always written to the operating system audit trail. DB_EXTENDED has this functionality, plus it records SQL text and SQL bind variables.

8. Click Apply.

9. Restart the Oracle Database instance.

   From a command line, enter the following commands:

   sqlplus sys as sysoper
   Enter password: password
   
   SQL> SHUTDOWN IMMEDIATE
   SQL> RESTART
   

   At this point, you can check the AUDIT_TRAIL setting by entering the following command:

   SQL> SHOW PARAMETER AUDIT_TRAIL
   
   NAME                     TYPE            VALUE
   ------------------------ --------------- ---------------------------------\
   audit_trail              string          DB_EXTENDED