About Audit Records
Audit records include information about the operation that was audited, the user who performed the operation, and the date and time of the operation. Depending on the type of auditing you choose, you can write audit records to data dictionary tables, called the database audit trail, or in operating system files, called the operating system audit trail.
If you choose to write audit records to the database audit trail, Oracle Database writes the audit records to the
SYS.AUD$ table for default and standard auditing, and to the
SYS.FGA_LOG$ table for fine-grained auditing. Both of these tables reside in the
SYSTEM tablespace and are owned by the
SYS schema. You can check the contents of these tables by querying the following data dictionary views:
"Finding Information About Audited Activities" describes more data dictionary views that you can use to view to contents of the
If you choose to write audit records to an operating system file, you can write them to either a text file or to an XML file. You can check the contents of an audit XML file by querying the
V$XML_AUDIT_TRAIL data dictionary view.