The Database Alert Log uses database triggers, Oracle Audit trails and a Scheduled
Task to transfer data between Audit trail and Database Alert Log.
There are three different ways to write to the Database Alert Log:
Direct from a PL/SQL Package, usually as an Autonomous transaction.
From a PL/SQL Package via a database trigger that catches what to log.
Through Oracle Audit Trail (that holds data in AUD$ table), and is transferred
to Database Alert Log through a Scheduled Task.
Note: Using database triggers and Oracle Audit trail may generate some
overhead.
Essentially, the functionality exists to make trouble shooting and logging easier
if necessary.
