Audit analysis

The audit analysis is extremely important. This chapter contains the following information:

  • The format of audit records that the database server produces
  • How to perform audit analysis with or without SQL
  • How to extract audit information from the audit trail for quick viewing
  • How to load that data into a database for analysis with SQL
  • How best to perform audit analysis on the extracted audit information

This chapter applies whether you use the database server or your operating system to store and maintain the audit trail. An overview of the audit analysis process is in Overview of auditing with the HCL OneDB secure auditing facility.