Capture an Oracle 10g audit trail in XML format

January 24, 2008

[From Builder AU]

The Oracle database has long had the ability to audit selected types of operations against the database, storing the audit trail in a system table. This table, SYS.AUD$, resides in the data dictionary. On some operating systems, you can also write audit records to the operating system's own event logging subsystem.

Oracle 10g added a third option: The ability to write to files in an operating system directory. These files can be written in XML.

The article continues at http://www.builderau.com.au/program/oracle/soa/Capture-an-Oracle-10g-audit-trail-in-XML-format/0,339028441,339285373,00.htm