Oracle Utilities - OCP: Oracle Database 12c Administrator Certified Professional - page 605

6. This example shows how to audit both Oracle Database Pump export and import
operations.
SQL> CREATE AUDIT POLICY audit_datapump_all_pol
2 ACTIONS COMPONENT=DATAPUMP ALL;
Audit policy created.
SQL> AUDIT POLICY audit_datapump_all_pol BY SYSTEM;
Audit succeeded.
SQL> NOAUDIT POLICY audit_datapump_all_pol BY SYSTEM;
Noaudit succeeded.
SQL>
7. Query the DP_ columns of the UNIFIED_AUDIT_TRAIL data dictionary view to access the
audit trail for Data Pump operations.
Here's the query you'll need to execute to view the Data Pump operations in the unified
audit trail:
SELECT DP_TEXT_PARAMETERS1, DP_BOOLEAN_PARAMETERS1
FROM UNIFIED_AUDIT_TRAIL
WHERE AUDIT_TYPE = 'DATAPUMP';
Auditing SQL*Loader Operations That Use Direct Path Mode
You can perform auditing on SQL*Loader direct path loads only, to monitor and record
user database actions. As mentioned previously, SQL*Loader uses unified auditing.
As mentioned in the previous section on auditing Data Pump activities, you'll need to set up
an audit policy specifically for SQL*Loader activities using the CREATE AUDIT command and
set the COMPONENT clause to DIRECT LOAD ; then enable it using the AUDIT POLICY statement.
Here's an example of how to create and audit an Oracle SQL*Loader unified audit policy:
SQL> CREATE AUDIT POLICY audit_direct_sqlldr_pol
2 ACTIONS COMPONENT=DIRECT_LOAD LOAD;
Audit policy created.
SQL> AUDIT POLICY audit_direct_sqlldr_pol BY SYSTEM;