To effectively manage the audit trail:
Be sure that auditing is installed with two or more tables, each on a separate device. If not, consider adding additional audit tables and devices.
Write a threshold procedure and attach it to each audit table segment.
Set configuration parameters for the audit queue size and to indicate appropriate action should the current audit table become full.
The following sections assume that you have installed auditing with two or more tables, each on a separate device. If you have only one device for the audit tables, skip to “Single-table auditing”.