Call now: 252-767-6166  
Oracle Training Oracle Support Development Oracle Apps

 E-mail Us
 Oracle Articles
New Oracle Articles

 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog

 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Oracle Support

 SQL Tuning

 Oracle UNIX
 Oracle Linux
 Remote s
 Remote plans
 Application Server

 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S


 Consulting Staff
 Consulting Prices
 Help Wanted!


 Oracle Posters
 Oracle Books

 Oracle Scripts

Don Burleson Blog 







dba_audit_trail tips

Oracle Database Tips by Donald BurlesonMarch 1,  2016

Question:  I have been the  dba_audit_trail view for auditing,  What is the  dba_audit_trail view and what auditing information is contained in this  dba_audit_trail DBA table?

Answer:  The dba_audit_trail is a view based on the aud$ table which decodes most of the values inside the table to present it in a user understandable manner. For instance, the column spare1 in aud$ actually stores the Operating System User Name.  For a full treatment of dba_audit_trail, see the book Oracle privacy security auditing.

The column os_username in this view gets its value from that column in the aud$ table. Similarly, the column action# column holds the user's action in a numeral form. For example, the number 108 indicates granting system privilege.

The view decodes the numerical representation for the actions and presents the information in the column action_name. Therefore, this view is actually more useful for analysis than the aud$ table itself.

The following views are based on the dba_audit_trail view.

  • user_audit_trail:  This view is based on all the columns of the dba_audit_trail view, but presents information on the current logged in user only. Unlike other data dictionary view, there is no equivalent all_audit_trail view, as it is not relevant in this case.
  • dba_audit_exists:  This is an audit trail of the entries where the operation failed due to non-existing objects. This is actually filtered from the view dba_audit_trail where the return code is a value other than zero.
  • dba_audit_session:  This records all database connect and disconnect activity. It also records if the action failed, for example, failure due to a security violation.
  • dba_audit_statement:  This view contains information about users entering statements that do not actually access the data inside an object, e.g. alter system, grant, revoke on objects, etc.
  • dba_audit_object:  Finally, this view shows all the audit records that were based on database object accesses:  e.g. a user selected from a table, or altered another table, etc.

Also see this books on Oracle auditing: Oracle Forensics: Oracle Security Best Practices

Oracle Training from Don Burleson 

The best on site "Oracle training classes" are just a phone call away! You can get personalized Oracle training by Donald Burleson, right at your shop!

Oracle training



Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


Copyright © 1996 -  2017

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.

Remote Emergency Support provided by Conversational



Oracle Training at Sea
oracle dba poster

Follow us on Twitter 
Oracle performance tuning software 
Oracle Linux poster