# What Is Oracle 12 Unified Auditing? The View UNIFIED_AUDIT_TRAIL with 94 Columns

- URL: https://www.integrigy.com/oracle-security-blog/what-oracle-12-unified-auditing-view-unifiedaudittrail-94-columns
- Published: 2014-11-24
- Type: Blog Post
- Products: Oracle Database
- Focus areas: Auditing

What is Oracle 12c Unified Auditing? The short answer is the view UNIFED_AUDIT_TRAIL. This view consolidates all logging and auditing information into a single source. Regardless of using either Mixed Mode or Pure Unified Auditing, the SYS.UNIFIED_AUDIT_TRAIL can be used.

The key column in SYS.UNIFIED_AUDIT_TRAIL is AUDIT_TYPE. This column shows from which Oracle component the log data originated -

<table>
<thead>
<tr>
<th colspan="3"><p><strong>SYS.UNIFIED_AUDIT_TRAIL Component Sources</strong></p></th>
</tr>
<tr>
<th><p><strong>Column AUDIT_TYPE Value</strong></p></th>
<th><p><strong>Description</strong></p></th>
<th><p><strong>Number of Columns in Table</strong></p></th>
</tr>
</thead>
<tbody>
<tr>
<td><p>Standard</p></td>
<td><p>Standard auditing including SYS audit records</p></td>
<td><p>44</p></td>
</tr>
<tr>
<td><p>XS</p></td>
<td><p>Real Application Security (RAS)and RAS auditing</p></td>
<td><p>17</p></td>
</tr>
<tr>
<td><p>Label Security</p></td>
<td><p>Oracle Label Security</p></td>
<td><p>14</p></td>
</tr>
<tr>
<td><p>Datapump</p></td>
<td><p>Oracle Data Pump</p></td>
<td><p>2</p></td>
</tr>
<tr>
<td><p>FineGrainedAudit</p></td>
<td><p>Fine grained audit(FGA)</p></td>
<td><p>1</p></td>
</tr>
<tr>
<td><p>Database Vault</p></td>
<td><p>Data Vault(DV)</p></td>
<td><p>10</p></td>
</tr>
<tr>
<td><p>RMAN_AUDIT</p></td>
<td><p>Oracle RMAN</p></td>
<td><p>5</p></td>
</tr>
<tr>
<td><p>Direct path API</p></td>
<td><p>SQL*Loader Direct Load</p></td>
<td><p>1</p></td>
</tr>
<tr>
<td></td>
<td><p>Total</p></td>
<td><p>94</p></td>
</tr>
</tbody>
</table>

If you have questions, please contact us at <mailto:info@integrigy.com>

## Reference

- Integrigy Oracle 12c Unified Auditing Whitepaper [Oracle 12c Unified Auditing](https://www.integrigy.com/security-resources/oracle-12c-unified-auditing)
- For a full description of each column in the view see the Oracle Database Reference 12*c* Release 1 (12.1) <http://docs.oracle.com/database/121/REFRN/refrn29162.htm#REFRN29162>
